SQL>SELECT ENAME,SAL FROM EMP WHERE SAL>(SELECT AVG(SAL) FROM EMP);

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

Question Posted / amit

Answer Posted / amit

SQL>SELECT ENAME,SAL FROM EMP
WHERE SAL>(SELECT AVG(SAL) FROM EMP);

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what are ddl statements in mysql? : Sql dba

1269

describe mysql connection using mysql binary. : Sql dba

1124

Why indexing is needed?

1046

How do I create a sql script?

1143

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2613

What is crud diagram?

994

What does dml mean?

1044

What is primary key and unique key?

1168

Can we rename a column in the output of sql query?

1043

Is mariadb a nosql database?

1102

What is dml statement?

1003

What is a temporal table?

983

How many types of functions are there in sql?

1009

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

1022

What are types of exception?

963