Differences between UNIQUE and DISTINCT in select statements26 117127
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, Nitin5 10350
Explain Features of WordPress?
How to use earthing on shipments.
What is Standard observer?
How many categories of data types in oracle?
what are the differences among rownum, rank and dense_rank? : Sql dba
Give me At Least 5 Differences between DOCUMENTATION OBJECT MODEL(DOM)and COMPONENT OBJECT MODEL(COM)? Interviewer said me to WRITE the difference only in points not as you WRITE a paragraph ???? only in points
Procedure to push the app in appstore?
Give an example where you need jsp custom tag?
What is Relationship set?
Can one drop a column from a table?
What is unix operating system?
Explain first() operation in Apache Spark RDD?
How many people have left in the last year?
What is called cognos reporting tool?
This process applies evaluation criteria to the bids and proposals received from potential vendors: A. Solicitation B. Contract Administration C. Source Selection D. Quality Assurance