Where is pl sql used?
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 is substitution variable in pl sql?
Write a query to find the names of users that begin with "um" in sql?
what is timestamp in mysql? : Sql dba
What are the different types of joins in sql?
How can get second highest salary in sql?
What is rownum?
What are the popular database management systems in the it industry?
What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.
what is organisational index?
How do rank () and dense_rank () differ?
What are the types of queries in sql?