Answer Posted / prasuna

Alternate 1

Define a cursor which holds the empname,salary and annual
renumeration
Use this cursor in a PL/SQL Block to find the emps who earn
30000 or more.

example :
Declare
cursor cl is select empname,salary,(salary*12)annual
renumeration
Begin
for i in cl
Loop
if i.annual renumeration > 30000 then
dbmsoutput.putline(empname);
end if
end

Approarch2
Write a stored function the take emp salary as i/p and
returns annual salary

Using this function in select statement can find the list
of emps who earn more than 30000

What is difference between rank () row_number () and dense_rank () in sql?

1048

---

how to use myisamchk to check or repair myisam tables? : Sql dba

910

---

What is sql catalog?

961

---

what is myisam? : Sql dba

999

---

What is tuple in sql?

1004

---

Write a query to display the current date in sql?

966

---

What are the syntax and use of the coalesce function?

1102

---

What is the advantage of index in sql?

914

---

Is sql a backend language?

1037

---

What is the meaning of disabling a trigger?

1110

---

What is sql and also describe types of sql statements?

993

---

How to make a copy values from one column to another in sql?

978

---

How to revise and re-run the last sql command?

1098

---

What is the max nvarchar size?

896

---

Why do we use procedures in sql?

1017

---