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
- 14876 Views
- 247Customer, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravikiran
select top 2(salary) from emp_sal where
salary in (select sal from emp_sal order by sal desc)
| Is This Answer Correct ? | 2 Yes | 3 No |
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What are the different authentication modes in sql server?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
How are SQL Server databases physically stored under Windows 2000?
What is nested transaction?
How to list all login names on the ms sql server?
How to use go command in "sqlcmd"?
What are different backups available in sql server?
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
What do you understand by mirroring and mention the advantages of the mirroring?
What are four major operators that can be used to combine conditions on a where clause?
one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
