1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how to retrieve the top 3 salaries of the table using rownum

Question Posted / deva

Answers were Sorted based on User's Feedback



how to retrieve the top 3 salaries of the table using rownum..

Answer / vivek dubey

select salary_column from salary_table
where rownum<4
order by salary_column desc

Is This Answer Correct ?    24 Yes 42 No

Post New Answer

More SQL PLSQL Interview Questions

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

How do you write an inner join query?

0 Answers  

Define sql delete statement.

0 Answers  

Why do we use triggers?

0 Answers  

What are sql data types?

0 Answers  




Can a foreign key have a different name?

0 Answers  

What is partition by in sql?

0 Answers  

what is global table

7 Answers   iFlex,

How can use stored procedures in sql?

0 Answers  

How to create your own reports in sql developer?

0 Answers  

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 Answers   TCS,

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories