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
11995 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

Can a key be both primary and foreign?

943

Which are the different case manipulation functions in sql?

952

How exception is different from error?

969

How to find 3rd highest salary of an employee from the employee table in sql?

1035

What is Materialized View? In What Scenario we Use Materialized View?

9396

What is a trigger word?

961

List the various privileges that a user can grant to another user?

988

what is meant by urlencode and urldocode? : Sql dba

1089

Can 2 queries be executed simultaneously in a distributed database system?

1082

What is meaning of <> in sql?

1019

What is rank dense_rank and partition in sql?

972

What is a delimiter in sas?

978

What are pl/sql packages?

1035

What is the most common sql injection tool?

993

What is a heap in sql?

991