a query to select maxmun 3 salaries of employee table
Answer Posted / kumari
SELECT TOP (3)with ties empsalry
FROM empsalr
order by empsalry desc;
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Explain the difference between a procedure and a function?
How to assign values to data fields in record variables?
What is a trigger oracle?
What is sharded cluster?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Explain temporal data types in oracle
What are the logical operations?
Why do you use stored procedures and state some of its disadvantages?
How to initialize variables with default values?
How do I uninstall oracle client from windows?
How to shutdown your 10g xe server from command line?
What are a cluster and non-cluster index?
How to select some columns from a table in oracle?
How to use "out" parameter properly?