Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Add defination in column while create table
-- See total column CREATE TABLE TestTable (ID INT, Value1 INT,Value2 int,Total as Value1+Value2) INSERT INTO TestTable (ID, Value1,Value2) SELECT 1, 10,10 UNION ALL SELECT 2, 20,20 UNION ALL SELECT 3, 30,30 UNION ALL SELECT 4, 40,40 UNION ALL SELECT 5, 50,50 UNION ALL SELECT 6, 60,60 UNION ALL SELECT 7, 70,70 GO SELECT ID, Value1,Value2,Total FROM TestTable
run
|
edit
|
history
|
help
0
Audit Example
do several updates at once
BRYAN_BD
string concatenation as aggregate operator in group by
SQL Sequence
1D Hotel
1
Task_4_Final
ss
Arif