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
What is nvarchar in sql?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
Can we use loop in sql?
What is synchronized subquery?
What are the different tcl commands in sql?
Can we use ddl statements in stored procedure sql server?
Are sql connections encrypted?
Which is faster view or stored procedure?
Is sql a microsoft product?
How many types of triggers exist in pl/sql?
How do I run pl sql in sql developer?
What are database links used for?
What is the difference between Union and Union all. Which is faster.
Sql technical questions
Is primary key an index?