how to retrieve the top 3 salaries of the table using rownum
Answer Posted / manivasan.s.,
select salary from salary_table
where rownum <4
order by salary desc
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What are views in sql?
What are all the different types of indexes?
What is pivot table in sql?
What are different types of functions in sql?
What is a join?
Can we change the table name in sql?
What will you get by the cursor attribute sql%notfound?
What is exception? What are the types of exceptions?
how to create a test table in your mysql server? : Sql dba
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
How many sql databases can you have on one server?
What is sql partition function?
Does mysql_real_escape_string prevent sql injection?
Is left join inner or outer?
What is update query?