Differences between UNIQUE and DISTINCT in select statements26 113813
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 9777
how do you choose the cable size as per amps rating & the voltage drop for the same.
why we permissive overreach in distance protection.where it is applicable to use in long r short lines
can one defect be mapped to more than one test script in manual testing
write a program for the normal snake games find in most of the mobiles.
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
any book or article on pumped concrete.
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What application areas are you comfortable in?
Which steps do you take to overcome a prospect's sales resistance?
Excise Duty Applicable for Assembly Materials E.g: I.T Products (Security Systems)
what i would like to contribute to bhel,s growth
Why we make body earthing of transformer and what will be the size of the copper wire for this purpose related to KVA Capacity of the Transformer as per code.
how impurity is analyzed in a tablet
why you are join as a quality analyist ?