Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Hack_this
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' /* Create a table called NAMES */ CREATE TABLE NAMES(Id integer PRIMARY KEY, Name text); /* Create few records in this table */ INSERT INTO NAMES VALUES(1,'Tom'); INSERT INTO NAMES VALUES(2,'Lucy'); INSERT INTO NAMES VALUES(3,'Frank'); INSERT INTO NAMES VALUES(4,'Jane'); INSERT INTO NAMES VALUES(5,'Robert'); INSERT INTO NAMES VALUES(6,'Husam'); INSERT INTO NAMES VALUES(7,'Potato'); /* Display all the records from the table */ SELECT * FROM NAMES;
run
|
edit
|
history
|
help
0
CTE reqursive query
Xml Excercise 3
SQL_Joins_RankingFunctions
SQL2
SQL Test
DBMS 4/9/20
Exam_1_Final
find count of employees with salary more than their managers
nnnnn
test22