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.
Answers were Sorted based on User's Feedback
Answer / prasuna
Alternate 1
Define a cursor which holds the empname,salary and annual
renumeration
Use this cursor in a PL/SQL Block to find the emps who earn
30000 or more.
example :
Declare
cursor cl is select empname,salary,(salary*12)annual
renumeration
Begin
for i in cl
Loop
if i.annual renumeration > 30000 then
dbmsoutput.putline(empname);
end if
end
Approarch2
Write a stored function the take emp salary as i/p and
returns annual salary
Using this function in select statement can find the list
of emps who earn more than 30000
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ajit nayak
select ename,sal,(sal*12)
from emp
where (sal*12) > 30000;
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / 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 |
Answer / venkat
Declare
cursor cl is select ename,sal,(sal*12) AS annualSAL FROM EMP;
i emp%rowtype;
Begin
for i in cl
loop
if i.annualSAL > 30000 then
dbms_output.put_line(i.ename);
end if;
end loop;
end;
Is This Answer Correct ? | 0 Yes | 1 No |
What do you mean by dbms? What are its different types?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
How does stored procedure reduce network traffic?
How do you change a value in sql?
What are the different types of dbms?
what are the 'mysql' command line options? : Sql dba
Is left join faster than join?
Define tables and fields in a database
how would you enter characters as hex numbers? : Sql dba
Can you join a table to itself?
What are the parts of a sql statement?
Can we use pl sql in sql server?