please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 11781 Views
- 247Customer, I also Faced
- E-Mail Answers
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
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What are the different types of collation sensitivity?
What is resource db in sql server?
How do you open a cluster administrator?
What is Extended user-defined?
What do you mean by authentication modes in sql server?
What is the difference between insensitive and scroll cursor?
How to execute the cursor queries with "open" statements?
Explain about SQLOS?
What is default constraint?
What is 1nf 2nf and 3nf?
Explain candidate key, alternate key, and composite key?
Explain the functionalities that views support?
How to compare the top two records using sql?
How to round a numeric value to a specific precision?
