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 to start oracle sql developer?

755


What is data profiling in sql?

746


how to see the create table statement of an existing table? : Sql dba

738


What is pl sql commands?

732


What is pl sql package?

797






How do I run sql?

828


Why do we use procedures?

698


What is sp_helptext?

774


What are the different types of sql commands?

787


What are the types of variables use in pl sql?

691


Does sql use python?

757


can sql servers linked to other servers like oracle? : Sql dba

751


What is the maximum number of triggers, you can apply on a single table?

736


Is null operator in sql?

792


Is sql better than access?

716