define a variable representing the expression used to
calculate on emps total annual remuneration.use the
variable in a statement which finds all emps who can earn
30000 a year or more.
- 5 Answers
- 11122 Views
- I also Faced
- E-Mail Answers
Answer Posted / padmalatha
select Empno,Annual_Salary=sum(Month_Salary) from
Employee_Salary
group by Empno having sum(Month_Salary)>30000
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is full form of rtm?
What are the two different parts of the pl/sql packages?
How does sql developer connect to oracle database?
What is before trigger?
how to convert numeric values to character strings? : Sql dba
What is a database event trigger?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is sap sql?
what are different types of collation sensitivity? : Sql dba
What are user defined functions?
What is the difference between join and natural join?
Can we use commit inside a trigger?
What view means?
What is the difference between partitioning and sharding?
How many indexes can be created on a table in sql?
