Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SqlServer1282018
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' CREATE TABLE Employee ( Employee_Id varchar(20), FName varchar(20), LName varchar(20), Gender char(1), ); insert into Employee(Employee_Id, FName, LName, Gender) values ('1001','Rohit','Sharma', 'M') insert into Employee(Employee_Id, FName, LName, Gender) values ('1003','Mohit','Sharma', 'M') insert into Employee(Employee_Id, FName, LName, Gender) values ('1005','Rohini','Verma', 'F') insert into Employee(Employee_Id, FName, LName, Gender) values ('1004','Rohan','Verma', 'M') select * from Employee
run
|
edit
|
history
|
help
0
Write('Well done ma boy');
by X o X, 3 years ago
by X o X, 3 years ago
Please
log in
to post a comment.
Preppin Data Challenge - Week 9
Kill all connections to given database
Select empID whose salary is greater than their managers
Libros
test1
Exa
Table
Merge statement
Using pre-built schema in sql server
Adding, subtracting, rounding and calculating differences
Write('Well done ma boy');
by X o X, 3 years agoby X o X, 3 years ago
Please log in to post a comment.