Answer Posted / xxx

select ename, salary from
(Select ename, salary, rownum
FROM emp where rownum<=3
Order by salary )
where rownum = 1
;

How do I edit a stored procedure?

556

---

How does cross join work in sql?

535

---

What are the operators used in select statements?

578

---

Enlist some predefined exceptions?

582

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

621

---

---

What is pivot in sql?

510

---

What is the difference between microsoft access and sql server?

533

---

How do I debug a stored procedure?

629

---

Is pl sql useful?

539

---

What is the usage of the distinct keyword?

690

---

What are the different types of triggers?

593

---

What is acid property in a database?

586

---

What is cursor explain with example?

553

---

What is pragma in pl sql?

599

---

What are the parameter modes supported by pl/sql?

534

---