please tell me the query to get details of the employee
having the second largest salary
Answer Posted / ss
select max(salary) from emp
where salary<(select max(salary) from emp)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to make a column nullable?
What is filestream?
What are the differences between union, intersect, and minus operators?
What are two difference between sql azure and azure tables?
What is self join in sql server joins?
Explain about nested stored procedure?
How to create a trigger for insert only?
What does top operator do?
What are character string data types in ms sql server?
Explain acid?
When columns are added to existing tables, what do they initially contain?
Why should we go for stored procedures? Why not direct queries?
Explain where clause?
Can coalesce return null?
How efficient you are in oracle and SQL server?