Рет қаралды 546
SQL Hindi Playlist : • SQL Tutorials-Hindi
MS SQL English Playlist : • SQL Tutorial-English
#mssqlserver , #sqlserver , #mssql , #database , #technology , #nosql , #informationtechnology , #sqldeveloper , #dba , #mysqldeveloper , #sqlservergeeks , #sqlservers, #sqlserveres , #mysql , #databaseadministrator , #mysqlserver , #trends ,
#sql #sqlserver #education #sqlinterviewquestions #mssqlserver #sqlforbeginners #sqltutorial #sqltraining #sqlcourse
CREATE TABLE [Sales](
[ORDER_DAY] date,
[ORDER_ID] varchar(10) ,
[PRODUCT_ID] varchar(10) ,
[QUANTITY] int ,
[PRICE] int
)
INSERT INTO [Sales] VALUES ('2015-05-01','ODR1', 'PROD1', 5, 5)
INSERT INTO [Sales] VALUES ('2015-05-01','ODR2', 'PROD2', 2, 10)
INSERT INTO [Sales] VALUES ('2015-05-01','ODR3', 'PROD3', 10, 25)
INSERT INTO [Sales] VALUES ('2015-05-01','ODR4', 'PROD1', 20, 5)
INSERT INTO [Sales] VALUES ('2015-05-02','ODR5', 'PROD3', 5, 25)
INSERT INTO [Sales] VALUES ('2015-05-02','ODR6', 'PROD4', 6, 20)
INSERT INTO [Sales] VALUES ('2015-05-02','ODR7', 'PROD1', 2, 5)
INSERT INTO [Sales] VALUES ('2015-05-02','ODR8', 'PROD5', 1, 50)
INSERT INTO [Sales] VALUES ('2015-05-02','ODR9', 'PROD6', 2, 50)
INSERT INTO [Sales] VALUES ('2015-05-02','ODR10','PROD2', 4, 10)
select * from Sales order by PRODUCT_ID,ORDER_DAY;
select PRODUCT_ID,count(PRODUCT_ID) as 'Count',count(ORDER_DAY) as 'Day' from Sales
group by PRODUCT_ID
Having count(Distinct ORDER_DAY) =2;
select * from Sales where order_day='2015-05-01'
select Order_day,Order_ID,product_ID from Sales
EXCEPT
select Order_day,Order_ID,product_ID from Sales where order_day='2015-05-01'