What are the types of triggers in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is orm in sql?
counting the no.of characters occurs in a string by using pl/sql function
How many types of sql are there?
What is a database event trigger?
What is difference between table and view?
Can we rename a column in the output of sql query?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is string data type in sql?
----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6
What is a sql schema used for?
what is online transaction processing (oltp)? : Sql dba
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)