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
- 10777 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajit nayak
select ename,sal,(sal*12)
from emp
where (sal*12) > 30000;
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Explain the the update statement in sql?
Does group by remove duplicates?
What is the difference between local and global temporary table?
Why should I use postgresql?
What is union and union all keyword in sql and what are their differences?
Why are sql stored procedures used?
What is a system versioned table?
What is nvl?
Why are cursors used?
Explain the steps needed to create the scheduled job?
What is meant by user defined function?
What are different types of statements supported by sql?
What operators deal with null?
How to take user input in pl sql?
what are the type of locks ? : Sql dba
