please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 12498 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
What do you understand by triggers and mention the different types of it?
How to receive returning result from a query?
What is the purpose of forms?
List the advantages of using stored procedures?
Define msdb database?
Indexes are updated automatically is the full-text index also updated automatically?
Define normalisation?
Explain what are the restrictions while creating batches in sql server?
How to test a dml trigger in ms sql server?
Explain about builtinadministrator?
How to create stored procedures with parameters in ms sql server?
What are the purposes and advantages stored procedure?
What is etl - extraction, transformation, and loading?
What is de-normalization and what are some of the examples of it?
What is extent? Types of extents?
