From an Employee table, how will you display the record
which has a maximum salary?

Answer Posted / amit kumar agarwalla

select * from employees
where salary=(select max(salary) from emplpoyees);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the most important ddl statements in sql?

578


what is data control language? : Sql dba

588


how tsql statements can be written and submitted to the database engine? : Transact sql

538


What are inner outer left and right joins in sql?

519


What are the differences between implicit and explicit cursors?

523






How do you update sql?

523


What is sql prepared statement?

546


What is optimistic concurrency control? : Transact sql

553


Is join an inner join?

537


Does a primary key have to be a number?

522


What is triggering circuit?

597


Does mysql support pl sql?

624


What are tuples in sql?

571


Why sql query is slow?

583


How many unique keys can a table have?

561