Answer Posted / zeljko
This answer_10 will work only if there is not order by used
on select statement.
I recommend using dense_rank function to get second row out
as in example;
SELECT * FROM (
SELECT id, first_name, salary,
DENSE_RANK() OVER(ORDER BY salary desc) row_order
FROM employee)
WHERE row_order = 2;
Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
How many postgresql users are there, worldwide?
What are all different types of collation sensitivity?
How many columns should be in an index?
Is left join same as inner join?
What is query optimization in sql?
Why we use sql profiler?
What is indexing in sql and its types?
What are analytic functions in sql?
Does sql require a server?
what are the 'mysql' command line options? : Sql dba
What is the difference between subquery and correlated query?
What is execution plan in sql?
How exception is different from error?
What is a crud api?
What is difference between hql and native sql?