t...

Do first left join Now all we need to do is put a where condition for null that's it. ...

--Get the second highest salary of HR department select * from #employee1 select * from #department1 ;with cte(empname,sal,row) as ( select empname,empsal,ROW_NUMBER()...

These are all basics but when asked in interview we make mistake. select * from #temp select AVG(id) from #temp  [5/3 or 5/5] select...

select * from EmployeeDetail Id EmployeeName 1 Anurag Nayak 2  Ritika mohanty 3     Siba Dalai 4 Biswa Panda Trick 1 ;with...

select * from EmployeeSalary order by id --o/p [Need employee id and the count that crossed more than 5000] --employeeid and count(>...

I wanted to truncate all tables in a cursor. But I was unable to do it as some table were being reference by foreign key constraint. This is the...