Differences between UNIQUE and DISTINCT in select statements26 124275
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 11989
How to define routes using Express?
How does counta work in excel?
What does apache spark stand for?
What information is defined in the software catalog?
Explain is fact table?
What is meant by binary tree traversal?
what could be the (realtime)bugs you come across in job portal and health care projects in terms of 1. high severity n low priority 2. high severity n high priority 3. low severity n low priority 4. low severity n low priority? pls its very urgent thanks n in advance n lukin forward for reply
What is a jsp directive?
How to display nth highest salary from a table in a mysql query?
Explain the three major types of rocks?
How to install zend on your local machine?
What is faker in laravel?
write a program to convert a expression in polish notation(postfix) to inline(normal) something like make 723+* (2+3) x 7 (not sure) just check out its mainly printing expression in postfix form to infix.
What is overloading in c#?