Differences between UNIQUE and DISTINCT in select statements26 119162
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 10673
Is mysql open source?
How do I create a variable number of variables?
How to add custom php codes in my drupal pages or blocks?
Can I delete program files x86?
What does hibernate.hbm2ddl.auto create means?
What is the difference between b and br tag?
How do you add a copyright symbol on a html page?
What is the difference between the ‘font’ and ‘fontmetrics’ class?
Explain more functions in brief in r?
In the short range what will happen to the levels above and below a population of secondary consumers of a numeric pyramid if a large number of individuals from this population dies?
Is it possible to calculate depreciation to the day?
Will you be successful if you continue working in this field?
What is the engine rating required for 1000 KVA Generator set. Calculations?
What is an rss email?
What is decode in static cache?