please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 12496 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / eswar
select max(salary) from emp
where salary<(select max(salary) from emp)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to drop an existing schema in ms sql server?
Explain following error properties?
How to execute a sql statement using odbc_exec()?
What is the data type of time?
What are the types of joins in sql?
How will you monitor replication latency in transactional replication? : sql server replication
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
How to replace given values with null using nullif()?
What is the difference between system objects and user objects?
Explain the steps to use transact-sql cursor?
What is public role in sql server?
How to convert character strings into numeric values?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
How secure is sql server database?
What is the meaning of sql server?
