Interested to Buy Any Domain ? << Click Here >> for more details...
Explain two easy sql optimizations.
- 0 Answers
- 959 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is error ora-12154: tns:could not resolve the connect identifier specified?
What is pl sql package?
What is trigger in sql?
What is exit statement?
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,
What are the built in functions of sql?
What are % type and % rowtype?
how can stop the sequence with mention the max value and with out mention the max value
What are the types of functions in sql?
What is partition in sql query?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What are different methods to trace the pl/sql code?
-
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)
