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.
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
How do you bind variables in pl sql?
What is cursor and why it is required?
Why is sql*loader direct path so fast?
Explain some predefined exceptions.
How long it takes to learn pl sql?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
Are stored procedures faster than dynamic sql?
Is it possible to sort a column using a column alias?
What is inner join in sql?
What is the purpose of a sql?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What company owns postgresql?
What are sql functions? Describe in brief different types of sql functions?
Does oracle use sql?
What is the difference between unique and primary key constraints?