Differences between UNIQUE and DISTINCT in select statements26 113107
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 9621
please post the interview questions for QA position in FACTSET
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
what happend to DC shunt motor if its field winding insulation becomes slightly weak? will that motor can run on full load or not explain in detail. thanks
1)How we can create a master group in segment builder? 2)What are the possible options in post processing of target group? 3)How can u create global target group for product proposal?
WHAT IS THE BANK RECONSILATION, WHAT THE FORMAT OF IT
Why do you want to join software field as you have done your BE in Electronics?
2. In a container filled with each of the following materials, at a porosity of 40%, determine the upward gradient required to cause the quick condition (a) Lead shot with a G = 13.75; (b) Fibre beads with G = 2.15; (c) Sand with a G = 2.32
What is Big Data?
Hi we are running tests remotely from quality center and pushing tests into qtp boxes remotely, and it does execution but while uploading results back into quality center it hangs in qtp box.If any one come across similar problem, please send me details how to handle this. Thanks kris
Give some examples of usage of BW statistics reports?
what is tie mechanism in CORBA/Visibroker?
hi i went for a walk to hsbc(call center) and i attended to written and telephonic round and next i have to face avp round what type of questions i have to face in that round please sujjest me
why you are opting BPO jobs if you having a degree of MSc?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
how do u manage scripts in winrunner when you application is changing frequently?