Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
arithmetic
create table salary(id integer,name varchar(30),sal integer,primary key(id)); insert into salary values(1,'abc',60000),(2,'xyz',50000),(3,'mpj',45000); select * from salary; select id,sal+1000 from salary; select id,sal-1000 from salary; select id,sal*2 from salary; select id,sal/2 from salary;
run
|
edit
|
history
|
help
0
SQL HW 1 Appline
Branch
Find effective count of employees within date range for each calendar week
Orders
samplequery
begginer1
RH
sql jueves
TO find max marks of students
correlated subquery & top & view & derived table & group by