Sql Tricky Interview Questions & Answers

Sql Tricky Interview Questions & Answers
This video helps you to understand the concept and logic of different sql command for interview questions.
SQL Tutorials Playlist
• SQL Tutorial-English
#sqlserver #sql #sqlinterviewquestions #mssqlserver #sqlforbeginners #education #rdbms #sqlcourse #sqlcommands

[@raviranjansingh5527]

Great sir,

[@lotusamaze1142]

Thanks

[@sandiplabade6755]

Nice 👌🏻👌🏻

[@lotusamaze1142]

Thank you! Cheers!

[@hemlatamingwal4768]

Thank you sir

[@lotusamaze1142]

All the best

[@shivamdobariya63]

these type of questions are asked for how many years of experience?

[@lotusamaze1142]

2-4 years

[@hemlatamingwal4768]

Thanks

[@lotusamaze1142]

Welcome

[@SakshiKumari-lc5wb]

Interview and scenario based questions

[@lotusamaze1142]

sure

[@SakshiKumari-lc5wb]

Please provide more videos

[@lotusamaze1142]

very soon

[@mohdsartaj9554]

DELETE Statement not work under WITH clouse, I m getting error please guide. Row_number work separately
Query- WITH CTE AS
(SELECT EMPID,deptid, ROW_Number() OVER(Partition by EMPID,deptid Order by EMPID,DeptID) Row_num FROM CPEMPSALES)
DELETE FROM CTE WHERE Row_num>1;

[@lotusamaze1142]

send me query and data in email [e-mail]

[@mohdsartaj9554]

@@lotusamaze1142 issue resolved. Delete function under CTE work only in ms sql sever not in my sql or postgre.
For those platform we can use Delete from (nested query)
Btw thanks