How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / rushi
select ename from employee where sal=(select disinct(max(sal) from employee));
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
Differentiate between translate and replace?
How to load data from external tables to regular tables?
How do I find the database name in oracle?
How to connect to the server with user account: sys?
Compare and contrast between sql and sql server and explain its various functions?
Is there any function in oracle similar like group_concat of mysql?
How to call a stored function with parameters?
What is a tns service name?
Why does oracle 9i treat an empty string as null?
Why should I use oracle database?
How to upsert (update or insert into a table)?
Where is the export dump file located?
WHAT IS ecc 6.0
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
what is the difference between substr and instr function in oracle?