Differences between UNIQUE and DISTINCT in select statements26 112157
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 9427
Hi, Cansomeone please send the system refresh doc , it's very urgent for me. Thanks in advance.
What are the generally asked questions for a Person who is attending Network protocol testing L2/L3.
please can any one tell me clearly about pid tuning i am confusing about this .how to tune pid easly?
types and working of compressor
why ,in CE configuration amp the output is 180 deg phase shift....?
I am a general practitioner and i want to ask about a case:a 10 year old boy with numerous monomorph(vesicular) acne in the face,it is his third eruption in the last year,with out any other diseases or sign and symptom exept for :his weight:56kg with truncal obesity height:153cm ,how can I approach it?is there any risk of precautious puberty while there is no manifestation of pubertal signs? bye the way his nutritional status and history seems to be good.
hi,when i am posting an entry on service tax it is not showing the business area.please guide me how to configure the business area so that the entry also shows the business area.please help as i need to configure it.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Merits & Demarits of Oil circuit & Air circuit breakers ?
Where mixed flow type compressors are used?
How is Telon(CA-Telon) used to build map?
it is possible to rotate the DG engine dc starter with wrong polarity connections? why?
help me with the question that might be ask on the interview for technical position
What will happen if boiler backfires?