Differences between UNIQUE and DISTINCT in select statements26 110351
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 9123
How use Budget in SAP, i want to see the report of variant between budget and actuals.
Which thing is maximum in RLC circuit at resonance a)power consumption b)inductive current c)capacitive voltage
How the sub ledgers(AP, AR) integrate with GL liability and receivable
hi;my name is rahul; im from india;well i have undergraduated student in english studies; then i caried on my studies in social developement departement from which after a year i v got a profesional licence degree in social institutions management; and now im applying for studying mba in usa ( concentration:marketing management)in2008; since 2years up to now im doing trainig in different associations; my sponsor is my uncle.my question is: do i have any chane to get visa in my case; and in ur opinions ladies and gentemlmen what s the most convincing motivations and answered could tell the in embassy? plz don t hesitate to share me ur point of views
How to set the number of reducers?
how do u calibrate the vacuum transmitter if it shows more reading
sir, I am from EEE branch.On feb 17 iam going to write an Exam for hindustan petrolium corporation Ltd.So plz send me the written exam pattern/Q's/interview questions.please mail to firstname.lastname@example.org
HI, FREINDS, I WANT TO KHOW IS THE CFP (CETICFIED FINANCIAL PLANNER) IS A GOOD COURSE, IS THEY ANY INSISTUTE IN HYDERABAD,IF ANY ONE DOING THIS COURSE PLEASE REPLY ME.
What are the Short cut Keys of Tally ERP?
Thumb rule for steel qty for 1m2 in kg/m2 column slab footing beam
when the time of backcharging the transformer three phases only enough or three phase with neutral is must.from these which one is the best one.
How to assign a Null value to a numeric field in a table?
Explain the Various types of Mergers at different stages of Industry life cyle? Give some Example of Merger companies.
why copper is a bad conducter at low temperature?
why the voltage and current in a long transmission line are called travelling wave?