Interested to Buy Any Domain ? << Click Here >> for more details...
From an Employee table, how will you display the record
which has a maximum salary?
- 29 Answers
- 37980 Views
- Cap Gemini, Exilant, Synechron, I also Faced
- E-Mail Answers
Answer Posted / anil
select * from test.emp where salary=(select max(salary) from test.emp);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the difference between primary key and unique key? : Sql dba
How to look at the current sql*plus system settings?
Why left join is used in sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is trigger and how to use it in sql?
What are pl sql data types?
What operating systems are supported by oracle sql developer?
What is compute?
what are the differences between require and include, include_once and require_once? : Sql dba
give the syntax of grant and revoke commands? : Sql dba
How to select all records from the table?
What is primary key and unique key?
what are properties of a transaction? : Sql dba
How would you reference column values before and after you have inserted and deleted triggers?
What are triggers and its uses?
