Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 20869 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
What is forward - only cursors / read only cursor?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What are the rendering extensions of ssrs?
What is optimization and its types?
What are statistics?
Explain about SQL server 2005?
When to use Inner join & when to use subquery?
How to compare the top two records using sql?
How to end a stored procedure properly in ms sql server?
How to verify a login name with sqlcmd tool?
Difference between aggregate functions of sql?
What is entity data services?
What is apply operator in sql?
What do you understand by a view?
