Answer Posted / vamsi nukala

select * from(select rownum as rno,emp.* from emp)where rno=2;

What is where clause in sql?

734

---

How does rowid help in running a query faster?

1157

---

What is view explain with example?

686

---

Can we update views in sql?

686

---

How do you declare a constant?

708

---

---

What is sql trigger example?

751

---

What is Histogram?

1279

---

How are sql commands classified?

803

---

Is sqlexception checked or unchecked?

723

---

what does the t-sql command ident_current does? : Transact sql

734

---

What is a heap in sql?

722

---

what does it mean to have quoted_identifier on? : Sql dba

894

---

What is the purpose of using pl/sql?

830

---

Is nosql faster than sql?

746

---

What is an inner join sql?

696

---