Is not equal in sql?
No Answer is Posted For this Question
Be the First to Post Answer
what is difference between stored procedures and application procedures,stored function and application function?
Does mysql support pl sql?
what are pl/sql collections?
4 Answers JPMorgan Chase, Oracle,
What is acid property in a database?
what are numeric data types? : Sql dba
What is sql basics?
What is partition in sql query?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is the difference between anonymous block and named block or stored procedure?
What is composite primary key in 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,
Write a sql select query that only returns each name only once from a table?