To find second largest salary in Employee table
Answer Posted / vikas kant
select Top 1 salary from emp_Table where salary in(select
Top 2 Salary from emp_Table order by salary desc)
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What is the difference between a function and a stored procedure?
How much space does sql server 2016 take?
How will you make an attribute not process? : sql server analysis services, ssas
In how many ways you can invoke ssrs reports?
What is stored procedures?
What are the purposes of floor and sign functions?
When we should use and scope of @@identity?
between cast and convert which function would you prefer and why?
what's the difference between delete table and truncate table commands? : Sql server database administration
How to create a simple stored procedure in ms sql server?
how you can get the list of largest tables in a database? : Sql server administration
What are a scheduled jobs or what is a scheduled tasks?
How connect excel to sql server?
Can you index views?
How to enter date and time literals in ms sql server?