Answer Posted / xxx

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

How to get unique records from a table?

920

---

Which sql statement is used to delete data from a database?

920

---

How is debugging done?

945

---

Is it possible to pass parameters to triggers?

1059

---

How do I delete a trigger?

931

---

What are primary key and foreign key and how they work?

946

---

What does := mean in pl sql?

1006

---

What are the advantages of stored procedure?

967

---

How can I delete duplicate rows?

984

---

What are expressions?

973

---

Do prepared statements prevent sql injection?

919

---

Is sql better than excel?

1089

---

Do foreign keys improve performance?

984

---

how to shut down the server with 'mysqladmin'? : Sql dba

979

---

how to convert dates to character strings? : Sql dba

1113

---