Answer Posted / sanjay kumar

Select * from
(select distinct salary, dense_rank()over (Order by salary desc) rk from emp)
Where rk=100;

How many sql statements are used? Define them.

580

---

How do you write an index?

529

---

Is sql between inclusive?

595

---

Which are the different character-manipulation functions in sql?

550

---

What is cross join example?

556

---

---

Explain what is a database?

652

---

What are different types of tables in sql?

533

---

Is primary key clustered or nonclustered?

568

---

What is the difference between row level and statement level trigger?

526

---

What is an intersect?

657

---

What is pl sql collection?

529

---

What is embedded sql in db2?

509

---

How do I view stored procedures?

547

---

Can we edit a view in sql?

555

---

What is sql rowcount?

559

---