how to retrieve the top 3 salaries of the table using rownum
Answers were Sorted based on User's Feedback
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 |
Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause
What is index example?
What types of commands can be executed in sql*plus?
what is sql? : Sql dba
What is difference between db2 and sql?
What is a temporal data type?
Does access use sql?
how to create table with in the procedure or function?
How many unique keys can a table have?
What is nosql example?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is the max nvarchar size?