Answer Posted / nitin

NAME EMP_ID
A 100
B 102
C 103
D 105
E 200
F 201
G 202
H 203
I 204

SELECT * FROM (select * from emp order by emp_id desc)
WHERE rownum <= 5

What are different types of tables in sql?

700

---

What is native sql query?

736

---

what is not null constraint? : Sql dba

721

---

What is asqueryable?

712

---

what is the syntax used for partition in tsql? : Transact sql

729

---

---

Explain the rollback statement?

769

---

what is a field in a database ? : Sql dba

755

---

Can we join tables without foreign key?

693

---

What is rank () in sql?

697

---

what is user defined functions? : Sql dba

744

---

How many sql commands are there?

851

---

How many types of literals are available in pl sql?

750

---

How does an execution block start and end in pl sql?

674

---

how to convert character strings to dates? : Sql dba

718

---

What is primary key and foreign key with example?

685

---