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
How does sql store data?
What are the built in functions of sql?
What is bind reference and how can it be created?
How do I audit the sql sent to the server?
How can I get the number of records affected by a stored procedure?
What is rank function in sql?
Explain the structure of pl/sql in brief.
What are properties of the transaction?
What is pragma in sql?
What is the difference between explicit and implicit cursors in oracle?
What is informix sql?
Can we use pl sql in mysql?
Is sql sequential or random?
What is cte?
Mention what is the plv (pl/vision) package offers?