What is a boolean in sql?
No Answer is Posted For this Question
Be the First to Post Answer
how to calculate the difference between two dates? : Sql dba
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 is the difference between sql and isql*plus?
What are the various restrictions imposed on view in terms of dml?
What is the difference between join and union.
27 Answers 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,
What are joins in sql?
what is primary key? : Sql dba
Are left and right joins the same?
How do I edit a trigger in sql developer?
write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35
What is PL/SQL Records?
How subquery works in sql?