Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 19803 Views
- CSS, I also Faced
- E-Mail Answers
Answer Posted / sujith
select empname,salary from(
select empname,salary, rank() over( order by salary desc) ss from emp)
where ss=2;
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
List some advantages and disadvantages of stored procedure?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Difference between report and query parameter. Why do we need different type of parameter?
what is blocking? : Sql server database administration
what is the main function of a query parameter?
How to rebuild master databse?
Can you explain what is sql server english query?
What is the difference between TRUNCATE and DROP?
What is database dimension? : sql server analysis services, ssas
How except clause is differs from not in clause?
Can we store videos inside the sql server table?
How do you Implement SSIS Packages in your Project?
What do you mean by authentication modes in sql server?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is the dbcc command and why is it used?
