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
12212 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

Differentiate between pl/sql and sql?

1133

Do foreign keys improve performance?

1011

What is spool?

1035

Why do we create stored procedures & functions in pl/sql and how are they different?

928

What found sql?

933

what is clause? : Sql dba

1054

what are the performance and scalability characteristics of mysql? : Sql dba

987

What is compilation error in pl sql?

961

Can we insert in sql function?

1068

How do you write a subquery?

1008

how to create a new table by selecting rows from another table in mysql? : Sql dba

1066

What is scope and visibility in PL/SQL?

1181

What is the basic form of sql query?

927

How to create a menu in sqlplus or pl/sql?

1105

how to add a new column to an existing table in mysql? : Sql dba

1049