What is the use of primary key?
No Answer is Posted For this Question
Be the First to Post Answer
What is a database trigger ? Name some usages of database trigger ?
Can we insert in sql function?
What is the difference between delete, truncate and drop command?
What are functions in sql?
what is called after appearing where clause
How many clustered indexes can you have?
What is the advantage of index in sql?
what are all the different normalizations? : Sql dba
consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.
what is sp_pkeys? : Transact sql
What is the clause we need to add in function body to return variable?
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,