query to retrive the employees whose sal is greater than avg
sal

Answer Posted / shiva

select e.* from emp e where e.sal>(select avg(sal) from emp);

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is nvarchar in sql?

518


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

511


Can we use loop in sql?

531


What is synchronized subquery?

591


What are the different tcl commands in sql?

618






Can we use ddl statements in stored procedure sql server?

512


Are sql connections encrypted?

554


Which is faster view or stored procedure?

500


Is sql a microsoft product?

493


How many types of triggers exist in pl/sql?

561


How do I run pl sql in sql developer?

624


What are database links used for?

591


What is the difference between Union and Union all. Which is faster.

844


Sql technical questions

775


Is primary key an index?

531