Interested to Buy Any Domain ? << Click Here >> for more details...
query to retrive the employees whose sal is greater than avg
sal
- 10 Answers
- 15072 Views
- TCS, I also Faced
- E-Mail Answers
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
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Which are the different case manipulation functions in sql?
how can we destroy the cookie? : Sql dba
How can a pl sql block be executed?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is an ndf file?
What does truncate mean in sql?
How can you fetch first 5 characters of the string?
Differentiate between % rowtype and type record.
What is the difference between execution of triggers and stored procedures?
What is auto increment?
Why do we use sqlite?
How would you pass hints to the sql processor?
How do I add a database to sql?
How run sql*plus commands that are stored in a local file?
