Differences between UNIQUE and DISTINCT in select statements26 121545
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 11244
Explain what are the functions of the typical server program? : Client server computing
what is isolation level at dead lock?
Hi, my interview is scheduled for IBM.can any on send sap crm faqs.my id is email@example.com in advance. siri
Which operator can be used to check if two numbers are equal or not in vbscript?
How is arsenic produced?
What are the advantages of sql?
What are java methods?
Can anyone share/send me QTP 8.2 Crack as I had it before but now it's virus affected. Pls send me on Sawale.firstname.lastname@example.org Thanks, ~Vijay
What is soil classification? : soil science
Which is best ide for java?
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
What are pre-processor & post-processor elements?
What is an assembly in .net?
From selenium ide how you can execute a single line?
What are the types of mapping?