Explain the components of sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is cte?
What is meant by Join? What are the different types of Joins available? Explain.
What is a crud api?
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 sql profiler in oracle?
what is mean by forward declaration and where we'll use it.
what is table? : Sql dba
What are string functions in sql?
What is rownum in sql?
what is sql profiler? : Sql dba
what are the authentication modes in sql server? How can it be changed? : Sql dba
what are the forced views