please tell me the query to get details of the employee
having the second largest salary
Answer Posted / ravikiran
select top 2(salary) from emp_sal where
salary in (select sal from emp_sal order by sal desc)
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What does executeupdate return?
What is the difference between inner join and equi join?
Explain stored procedure?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Do you know what are the steps to process a single select statement?
Can multiple columns be used in sql group by clause in ms sql server?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What are differences in between sql server 2012 and sql server 2016?
What is isnull() operator?
What are the advantages of user-defined functions over stored procedures in sql server?
Where to find ntwdblib.dll version 2000.80.194.0?
What are the 2 types of classifications of constraints in the sql server?
Does sql server use java?
What is user defined stored procedures?
How many types of local tables are there in sql server?