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

Is pl sql and postgresql same?

1142

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1026

How can we link a sql database to an existing android app?

1039

How does an execution block start and end in pl sql?

958

Can we commit inside a trigger?

1000

Explain lock escalation? : Transact sql

1210

what are all the different types of indexes? : Sql dba

1056

What is sql resultset?

995

What is pl sql commands?

1051

How can I change database name in sql?

1092

what is the difference difference between procedure and packages

10425

what tools available for managing mysql server? : Sql dba

1090

Does pl/sql support create command?

1124

What are aggregate and scalar functions?

1033

What do you mean by stored procedures? How do we use it?

1002