please tell me the query to get details of the employee
having the second largest salary
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 is normalization and what are the different forms of normalizations?
How to list all triggers in the database with sys.triggers in ms sql server?
How to find the list of fixed hard drive and free space on server?
how to rest identity columns in sql server
What are different types of collation sensitivity?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting
How can we improve performance by using SQL Server profiler?
How can I get data from a database on another server?
What is the difference between indexing and hashing?
Oracle (3259)
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)