select Empno,Annual_Salary=sum(Month_Salary) from Employee

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.

Question Posted / padmalatha

5 Answers
11989 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

Please Help Members By Posting Answers For Below Questions

Does db2 use sql?

885

Does inner join return duplicate rows?

925

Is sqlexception checked or unchecked?

917

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

952

How do I enable sql encryption?

964

What is mutating trigger?

965

How to place comments in pl/sql?

1095

How to change the order of columns in Oracle SQL Plus ?

992

Can we connect to postgresql using sql developer?

932

What are the different sql languages?

984

What is a data manipulation language?

962

How to take user input in pl sql?

1105

how to present a past time in hours, minutes and seconds? : Sql dba

942

What is pl sql variable?

932

Is record in pl sql?

914