From an Employee table, how will you display the record
which has a maximum salary?
Answer Posted / mohan
select * from emp where sal in(select max(sal) from emp);
or
select * from emp where sal=(select max(sal) from emp);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how does a local variable is defined using t-sql? : Transact sql
What is left inner join in sql?
What does stand for in sql?
What are aggregate and scalar functions?
what are properties of a transaction? : Sql dba
How do I remove sql plus from windows 10?
What is sql in oracle?
What are the different schemas objects that can be created using pl/sql?
Can we use join in subquery?
How delete all data from all tables in sql?
What is a unique key?
What view means?
What are tuples in sql?
What is cost in sql execution plan?
What are the datatypes available in pl/sql ?