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
12284 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 a materialized view? : Sql dba

1067

What is the default isolation level in sql server? : Transact sql

1033

how do you know the version of your mysql server? : Sql dba

1007

What is java sql drivermanager?

1104

What is primary key in db?

1014

Why function is used in sql?

951

How can you load multi line records? : aql loader

1082

How do I upgrade sql?

1005

What is use of term?

1068

Explain the update statement in sql

999

What are the different dml commands in sql?

1182

Does oracle roll back the transaction on an error?

1022

What is pl sql script?

1036

What is raw datatype in sql?

1050

What is microsoft t sql?

951