Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 52261 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohammad murtuza ali
select * from salary where rowno<6
| Is This Answer Correct ? | 4 Yes | 15 No |
Answer / amit bharane
select salary from employees
where rownum<=5
order by salary desc
| Is This Answer Correct ? | 3 Yes | 22 No |
Answer / mohammad murtuza ali
select * from SALARY where where rowno<6 and empname like
empname
| Is This Answer Correct ? | 2 Yes | 29 No |
Answer / sujith
select * from test_sujith where rownum < 6 order by item3 desc
| Is This Answer Correct ? | 2 Yes | 31 No |
What is an invalid partition table?
Does asenumerable execute the query?
What is a mutating table and a constraining table?
What is data control language?
What is before trigger?
What is the difference between database trigger and stored procedure?
how can we find the select statement is indexed or not?
Why use triggers in sql?
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
what is the syntax for using sql_variant_property? : Transact sql
I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.
table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
