Answer Posted / raveendran

SELECT EMP_BASICS,ROWNUM FROM EMPLOYEE_MASTER WHERE
EMP_BASICS IS NOT NULL AND ROWNUM<=3 ORDER BY EMP_BASICS
DESC

What is over () in sql?

529

---

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

521

---

How can you load multi line records? : aql loader

659

---

What is minus?

547

---

What is cursor in pl sql with examples?

481

---

---

What is package in pl sql with an examples?

549

---

Can we debug stored procedure?

525

---

How we can update the view?

603

---

Is pl sql different from sql?

536

---

how to use 'mysql' to run sql statements? : Sql dba

539

---

Why is theta join required?

664

---

What is a design view?

522

---

Is truncate ddl or dml?

545

---

How many tables can a sql database have?

533

---

How do sql databases work?

533

---