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 are the commands used in DCL?
What are the differences between having and where clause.
How to trouble shoot if unable to connect SQL Server
What is left outer join in sql server joins?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What are sparse columns?
How to Check if table exists in sql server?
What is executereader?
What is sql server management studio? : sql server management studio
What is key attribute?
Can binary strings be converted into numeric or float data types?
Can a table have 2 primary keys?
How do I clean up sql server transaction log?
What is data modeling and Reterminal integrity?
What are the main differences between #temp tables and @table variables and which one is preferred?