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
- 10773 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 do you mean by rowid?
What is sql integrity?
What is int identity in sql?
What is an oracle stored procedure?
What is schema in sql?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How do I tune a sql query?
Why do we use procedures?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What is the use of partition by in sql?
what are integrity rules?
What are the basic sql commands?
what is the syntax for using sql_variant_property? : Transact sql
what is the difference between $message and $$message? : Sql dba
What is the order of sql select?
