Answer Posted / kishore

select salery from (
(select salery ,rownum as num from
(select salery from employees order by salery desc)
where rownum <= 5 ))
where num = 5;

What is pl/sql table? Why is it used?

561

---

What is rank dense_rank and partition in sql?

539

---

Can we use ddl statements in stored procedure?

696

---

What are tables and fields in the database?

554

---

what is a table in a database ? : Sql dba

542

---

---

how to select first 5 records from a table? : Sql dba

509

---

explain the difference between bool, tinyint and bit. : Sql dba

526

---

What is string join?

557

---

What is example of database?

519

---

Can a table contain multiple foreign key’s?

575

---

Does truncate release storage space?

560

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

570

---

How do you delete duplicates in sql query using rowid?

541

---

What is update query?

549

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

618

---