how to get a list of indexes of an existing table? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
What is rename command in sql?
Write a query to find second highest salary of an employee.
What is online transaction processing (oltp)?
Explain aggregate functions are available there in sql?
What is database sql?
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,
How many types of keys are there in sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is sql character function?
How do you write a subquery?
What is input buffer in sql*plus?
How do I find sql profiler?