what is data control language? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
How to display all Friday's in a year with date?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
what is inline command?
What is the purpose of the partition table?
Is sql dba a good career? : SQL DBA
package specification-3 procedures package body-4 procedures how can i write for other procedure in package body
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 is a ddl command?
Which kind of parameters cannot have a default value in pl sql?
what is a composite primary key ? : Sql dba
How many commands are in sql?
what is myisam? : Sql dba
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)