Differences between UNIQUE and DISTINCT in select statements26 111313
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 9277
Thanks....But can u tell me how i use the QTP for GIS with one Example...
what is the difference between somatic hybridization and protoplast fusion?
why power factor is lagging and leading(i.e -1to +1)
How fuel oil consumed by medium engine?
when will triggars the at new event in abap and web dybn pro?
what reactive how to maintain
Explain transaction code KO88 or CO88.
I am Facing Issues with learing datepicker 1)when i first learn datepicker as current system date . 2)if i wanna runtime datepicker value it gives error
who will able to deduct the tds
Where do you view the results in Trap option?
What major clients have you closed over the last 4 months?
Identify the parts of indicator diagram?
What is scheduling
what are the common errors while doing integration,system,functional,regression,user acceptance testing? can anybody please let me know the answers it is too urgent???
What is the maximum No. of out going mccbs permitted from an LV distribution paqnel? What is the ampere relation between incomer and out going switch gears/mccbs?