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

Answer Posted / gourav

select salary,AVG_SALARY from z1
where salary>AVG_SALARY

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I run pl sql in sql developer?

747


What is a recursive stored procedure?

713


What is column?

622


What is offset in sql query?

709


what is the difference between nested subquery and correlated subquery?

643






Describe sql comments?

640


How do you remove duplicates without using distinct in sql?

586


How is pl sql different from sql?

634


Can ddl statements be used in pl/sql?

684


How do I find duplicates in sql?

602


what are the nonstandard string types? : Sql dba

693


How do I install microsoft sql?

610


Explain normalization and what are the advantages of it?

602


Explain foreign key in sql?

700


What is set serveroutput on?

742