Run Code
|
API
|
Code Wall
|
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
performance on update using subquery versus correlated update
kirthi
dbms pracs
20181cse0012dbmsca2
exp7
Finding gaps, NOT EXISTS clause analysis_1_put on a wall
stackoverflow_mysql_demo_data
Admno
create table with constraunt
https://www.hsbc.co.in/ways-to-bank/online-banking/9247/