Interested to Buy Any Domain ? << Click Here >> for more details...
Is t sql a programming language?
- 0 Answers
- 1070 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What are sql indexes?
Which join condition can be specified using on clause?
Difference between table function and pipelined function?
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 view means?
What is a self join ?
What is ROWID?
What is dense_rank in sql?
Differentiate between syntax and runtime errors.
What is a REF CURSOR? Compare strong and week ref cursor types.
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Is truncate ddl or dml?
-
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)
