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
- 11123 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
What is multiple partition?
What is left join in sql?
what are the features and advantages of object-oriented programming? : Sql dba
Does pdo prevent sql injection?
Is pl sql a programming language?
Can we insert data in view?
What is sql resultset?
What is a field in a database?
Why do we need a foreign key?
What is the difference between a subquery and a join?
What are the two parts of design view?
How does postgresql compare to "nosql"?
What is a primary key example?
What are the advantages of pl sql?
What are the possible values for the boolean data field?
