Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQl_QUEST_2_PRESENTATION_IMG_COUNT
CREATE TABLE EVENT_LOGS ( UserId INT, [TimeStamp] DATETIME ) GO INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (2, GETDATE()); INSERT INTO EVENT_LOGS VALUES (5, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (3, GETDATE()); INSERT INTO EVENT_LOGS VALUES (2, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (4, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (2, GETDATE()); INSERT INTO EVENT_LOGS VALUES (5, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (3, GETDATE()); INSERT INTO EVENT_LOGS VALUES (2, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (4, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (2, GETDATE()); INSERT INTO EVENT_LOGS VALUES (5, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (3, GETDATE()); INSERT INTO EVENT_LOGS VALUES (2, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (4, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (2, GETDATE()); INSERT INTO EVENT_LOGS VALUES (5, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (3, GETDATE()); INSERT INTO EVENT_LOGS VALUES (2, GETDATE()); INSERT INTO EVENT_LOGS VALUES (2, GETDATE()); INSERT INTO EVENT_LOGS VALUES (2, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); INSERT INTO EVENT_LOGS VALUES (4, GETDATE()); INSERT INTO EVENT_LOGS VALUES (1, GETDATE()); Go SELECT UserId, COUNT(UserId) AS IMAGE_COUNT FROM EVENT_LOGS GROUP BY UserId HAVING COUNT(UserId) BETWEEN 10 AND 20
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
a
NAMES
How to find 2nd highest salary
Print 10 records
Stored procedure ex1
emp 4
Status History
Creating tables in sql server
Rno 37 boat
Recursion and cte
Please log in to post a comment.