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
- 10230 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 varray in pl sql?
What are sql commands?
Why do we use subquery?
Why function is used in sql?
what is a view? : Sql dba
Can you have more than one trigger on a table?
Is mariadb nosql?
Which sorts rows in sql?
Can we join same table in sql?
What does count (*) do in sql?
Differentiate between sga and pga.
How we can update the view?
What are the advantages of sql? Explain
What is the difference between explicit and implicit cursors in oracle?
Is there a 64 bit version of ssms?
