Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
20181cse0065
create table std(snum int primary key, sname varchar(10), major varchar (10), level varchar (10), age int ); insert into std values (101, 'abhi', 'cse', 'jr', 19); insert into std values (102, 'anu', 'ise', 'sr', 18); select * from std; alter table std add fees float default 30000; alter table std add email varchar(40) default 'someone@gmail.com'; select * from std;
run
|
edit
|
history
|
help
0
nandhu
MSSQL_Q1
Demo
customer data
Program1
Window Funtions - RANK()
sql
tables creation
Second Query
Table