Answers for "mysql calculated column in where clause"

SQL
0

mysql calculated column

-- MySQL / Oracle:
ALTER TABLE table_name ADD double_count NUMBER(10, 2)
    GENERATED ALWAYS AS (account * 2) VIRTUAL;
-- SQL Server
ALTER TABLE table_name ADD [double_count] AS (acccount * 2);
Posted by: Guest on June-19-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language