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
- 39055 Views
- Cap Gemini, Exilant, Synechron, I also Faced
- E-Mail Answers
Answer Posted / kavitha nedigunta
select * from emp e,(select max(sal) sal
from emp)a
where e.sal= a.sal;
select * from emp
where sal in(select max(sal) from
emp);
| Is This Answer Correct ? | 29 Yes | 3 No |
Post New Answer View All Answers
What is sql lookup?
How do I edit a trigger in sql developer?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
what is the bond code in materialized view?
Which is the correct statement about truncate and delete?
How will you distinguish a global variable with a local variable in pl/sql?
What are the advantages of pl sql over sql?
What is plpgsql language?
Do we need to create index on primary key?
What is a database? Explain
How do I use google cloud in sql?
How to avoid using cursors?
How do you update f as m and m as f from the below table testtable?
How do I count rows in sql?
What is autocommit sql?
