Differences between UNIQUE and DISTINCT in select statements26 112782
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 9540
If you were given a chance to talk to the president what would you like to ask and why?
explain construction of lvdt?
Why we have to add 200mg Na2CO3 in preparation of 0.1N sodium thiosulfate solution?
Please is there any one working with ITR.COM? Having interview with them. Any tips will help.
Difference between different strategy groups.
which cultures or subcultures or standards are generally using as a positive control for total aerobic microbial count in API?
When looking at a flanged extension pipe and it is labeled DN20, just what does that mean or intel?
69,70 or 71 in box-1 ; 18,19, or 20 in box-2 ; 60,61, or 62 in box-3 get -3 , -4 , or -5 in box-2 in 3 steps.Use all operations i.e. ( +,-,*,/ ).
HOW TO CONVINCE CUSTOMER IN INSURANCE BPO JOB?
how is work pressure switch& level switch?what is the principle of this?
how do u really know that paging to disk is happening while u are using a lookup transform?
The efficiency of a pin fin with insulated tip is
What makes you better than the other people I'm seeing today?
How we create SQL Server 2005 Reporting Services ? Give me Sample
Is Genetic Engineering worth the cost and effort?