1. How to fetch all the duplicate records from the table.
2. How to fetch the second highest salary from the table.
Answer Posted / jyoti
even i m suffering from this Q. plz let me knw?
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
what's the information that can be stored inside a bit column? : Sql server database administration
What is difference between join and natural join?
What does the update command do?
Can we insert data into a view?
What is SQL Azure?
What is the difference between dataadapter and datareader?
Which command is used for user defined error messages?
How to identify current user in ssrs report?
What is a livelock?
What are drillthrough reports?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to retrieve error messages using odbc_errormsg()?
How to Check if table exists in sql server?
What is cursors? And what are the different types of cursor?
What is the Disadvantage of indexed sequential file.