select ename,sal,(sal*12) from emp where (sal*12)

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.

Question Posted / ajit nayak

5 Answers
12204 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

Please Help Members By Posting Answers For Below Questions

What is the most important ddl statements in sql are?

981

Can we insert in view in sql?

1037

Which is faster count (*) or count 1?

1009

Can we rollback truncate?

986

Explain alias in sql?

1027

How do I run a pl sql procedure in sql developer?

952

what is 'mysqldump'? : Sql dba

1092

What is the life of an sql statement?

999

What is sql and how does it work?

1149

Does asenumerable execute the query?

1026

What are the basic sql commands?

1070

What is a primary key sql?

1032

What is cursor and its types?

1047

How do I start sql from command line?

1001

what is the difference between delete and truncate statement in sql? : Sql dba

1213