Interested to Buy Any Domain ? << Click Here >> for more details...
How run sql*plus commands that are stored in a local file?
- 0 Answers
- 974 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Why stored procedures are faster than query?
how to rename an existing column in a table? : Sql dba
What is database migration?
Is left join faster than inner join?
What is a database trigger ? Name some usages of database trigger ?
How do you assign Construct the where clause without concatenating Field,value pairs?
What are all the different normalizations?
Explain constraints in sql?
Is it important to partition hard disk?
Why do we create views in sql?
What types of commands can be executed in sql*plus?
Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin
5 Answers Deloitte, Ness Technologies,
-
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)
