Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Count by days
CREATE TABLE [record]( [id][int] NOT NULL, [name][nvarchar](20) NOT NULL, [targetdate][date] NULL, PRIMARY KEY CLUSTERED ( [id] ASC )) INSERT INTO [record] VALUES (1,'Event 1','2017-09-10'); INSERT INTO [record] VALUES (2,'Event 2','2017-10-27'); INSERT INTO [record] VALUES (3,'Event 3','2017-10-25'); INSERT INTO [record] VALUES (4,'Event 4','2017-11-01'); INSERT INTO [record] VALUES (5,'Event 5','2017-11-05'); INSERT INTO [record] VALUES (6,'Event 6','2017-11-11'); INSERT INTO [record] VALUES (7,'Event 7','2017-12-20'); INSERT INTO [record] VALUES (8,'Event 8','2017-12-20'); INSERT INTO [record] VALUES (9,'Event 9','2018-11-5'); INSERT INTO [record] VALUES (10,'Event 10','2018-11-5'); INSERT INTO [record] VALUES (11,'Event 11','2018-11-5'); INSERT INTO [record] VALUES (12,'Event 12','2018-11-5'); SELECT * FROM [record]; -- The end output would be: passed = 1, tenDays = 3, thirtyDays = 6. Ideally I would also be able to return a count of all those over 30 days as well -- the exact format returned isn't too critical, as long as the numbers are returned in a known order/format I can interpret them
run
|
edit
|
history
|
help
0
top 3 salaries from each dept
Program1
check constraint
MC170402209
Sequence object -- New Feature of 2012 sql server
how-to-assign-a-random-value-in-a-select-statement-in-sqlserver
Ejercicios de SQL (I)9
sarthak rana
Second Query
kuy09:admin09@pkms99.info