Interested to Buy Any Domain ? << Click Here >> for more details...
please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 14496 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
How do I start sql server 2016?
What is bcnf normalization form?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What is difference between order by and group by?
What are the differences between char and varchar in ms sql server?
How do you know if sql server is running on your local system?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to provide default values to stored procedure parameters?
How to get the definition of a stored procedure back?
How to delete an existing database user?
What are the different types of lock modes in sql server 2000?
How does stuff differ from the replace function?
How to create new tables with "create table" statements in ms sql server?
What is a ddl statement?
What is stretch database in sql server?
