Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Table
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) ); INSERT INTO Persons (PersonID, LastName, FirstName, Address, City) VALUES (210, 'Vo', 'Matthew', 'Carrera Ct.', 'San Jose') INSERT INTO Persons (PersonID, LastName, FirstName, Address, City) VALUES (123, 'Doe', 'John', 'Quimby', 'San Jose') Select * from persons WHERE City = 'San Jose';
run
|
edit
|
history
|
help
0
repert
new
Program1
testing-2
ASDF
get date part from datetime
sum vs count with multiple options in group by clause
2021-03-06_LeetCodeSQL
Quiz
Merge statement