Can we use where clause with group by?
No Answer is Posted For this Question
Be the First to Post Answer
How many full-text indexes can a table have?
What information is maintained within the msdb database?
Explain difference between control flow and data flow?
Define left outer join?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
Explain user defined views?
What is a scheduled job or what is a scheduled task?
what protocol both networks use? : Sql server database administration
Explain acid?
In which situation you use Self joins?
1 Answers CarrizalSoft Technologies, HP, TCS,
How to recompile stored procedure at run time?
Distinguish between nested subquery and correlated subquery?