Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Student
CREATE TABLE Persons ( stdID int NOT NULL, firstName varchar(50) NOT NULL, lastName varchar(50), city varchar(55), country varchar(55), birthDate Date, PRIMARY KEY (stdID) ); CREATE INDEX idx ON Persons (lastName, firstName,birthDate);
run
|
edit
|
history
|
help
0
SQL_RankingFunctions
Mc170404738
Company DB
group_concat in sql-server
Demo
trigger
tarefaum
Count by days
Window Funtions - RANK()
Running Total