Answer Posted / soumya

select * from (select rownum, salary from emp order by
salary ) where rownum=100;

What is latest version of sql?

983

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

973

---

Does sql full backup truncate logs?

968

---

Is sql a programming?

936

---

What is the use of function in sql?

1029

---

What is an inconsistent dependency?

980

---

How do I find duplicates in sql?

879

---

Do we need to rebuild index after truncate?

976

---

What is the difference between microsoft sql and mysql?

921

---

what is a stored procedure? : Sql dba

1054

---

What is sql profiler in oracle?

1015

---

what is denormalization. : Sql dba

1045

---

Can we use pl sql in sql server?

1013

---

Explain the update statement in sql

918

---

How do you know if a relationship is 2nf?

877

---