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
How can Oracle users be audited?
Please explain oracle left join with an example?
What are the restrictions on external table columns?
Explain the use of record length option in exp command.
What is archive log in Oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
What is different types of joins?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is recovery manager(rman) backup in Oracle?
Which are the five query types available in oracle?
How do you bind variables in oracle?
How to concatenate two text values in oracle?
How to invoke the data pump import utility?
How to specify default values in insert statement using oracle?
What happens to the current transaction if the session is killed?