What does inner join mean?
No Answer is Posted For this Question
Be the First to Post Answer
List the various privileges that a user can grant to another user?
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 does myisamchk do? : Sql dba
What is the process of debugging?
What is dense_rank?
What is online transaction processing (oltp)?
How do you take the union of two tables in sql?
What is the use of desc in sql?
What is auto increment in sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is cursor explain with example?
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)