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.
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 a pl/sql block?
Can variables be used in sql statements?
What is the syntax and use of the coalesce function?
How do I filter in sql profiler?
Explain what is dbms?
How many types of triggers exist in pl/sql?
What is scope of pl sql developer in future?
what are numeric data types? : Sql dba
What is native sql query?
What is pragma in sql?
Can we use pl sql in sql server?
What is data types in sql?
Explain what is a field in a database and record in a database?
Whis is not false in primary key?
what is the syntax used for partition in tsql? : Transact sql