Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
PracticeDB
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table EMP(emp_id int ,emp_name varchar(50),emp_gender varchar(50),emp_phone bigint); insert into EMP (emp_id,emp_name,emp_gender,emp_phone) values (101,'Rahul','Male',9765676567); insert into EMP (emp_id,emp_name,emp_gender,emp_phone) values (102,'Shreya','Female',9565676567); insert into EMP (emp_id,emp_name,emp_gender,emp_phone) values (103,'Abhishek','Male',9445676567); insert into EMP (emp_id,emp_name,emp_gender,emp_phone) values (104,'Shruti','Female',9990676567); insert into EMP (emp_id,emp_name,emp_gender,emp_phone) values (105,'Ram','Male',9265676567); Select * from EMP;
run
|
edit
|
history
|
help
0
My data
Movies
SQL Directives Order of Execution
Test row_number() ordering when CTE referenced multiple times
Teacher
Movies
Empleados
Cinema latinoamericano
TRANHOANGLONG
Employee