Is sql sequential or random?
No Answer is Posted For this Question
Be the First to Post Answer
Why do we use joins?
..........refers to the disk mirroring
how to insert the records in particular position
How do you create a unique index?
What can sql server reporting services do?
What is implicit cursor in pl sql?
What is the difference between union and union all command?
How can you create Cursor with parametres ?
What is the difference between the sql*loader and import utilities? : aql loader
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, Nitin
5 Answers Deloitte, Ness Technologies,
Why is sql better than hql?
what tools available for managing mysql server? : Sql dba