How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / hari.sidd
SELECT ENAME
FROM EMPLOYEE
WHERE ESAL=MAX(ESAL);
| Is This Answer Correct ? | 1 Yes | 12 No |
Post New Answer View All Answers
What is a user role in oracle?
Explain what are clusters?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Explain oracle insert into command?
What is a system tablespace?
How to use windows user to connect to the server?
Write a syntax for update query in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
What are a collation and state the different types of collation sensitivity?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What happens to the data files if a tablespace is dropped?
What do you understand by database schema and what does it hold?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is where clause in oracle?