What is the use of index in sql?
No Answer is Posted For this Question
Be the First to Post Answer
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,
what the meaning of sql
What do you mean by “trigger” in sql?
What will you get by the cursor attribute sql%notfound?
Write a sql query to get the third highest salary of an employee from employee_table?
I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
Is sqlite good enough for production?
what is view? : Sql dba
Give an example of Full Outer Join?
How does left join work in sql?
What is the difference between row level and statement level trigger?
what happens if you no create privilege in a database? : Sql dba