Answer Posted / sagar

SELECT * FROM tab a
WHERE :n = (SELECT COUNT(rowid)
FROM tab b
WHERE a.rowid >= b.rowid);

How do you know if a relationship is 2nf?

518

---

What is rownum?

536

---

What is the difference between explicit and implicit cursors in oracle?

513

---

What are the types of dbms?

545

---

What is the plv (pl/vision) package offers?

613

---

---

Can we perform dml in function?

592

---

Write a query to display the current date in sql?

511

---

Can triggers stop a dml statement from executing on a table?

616

---

What are the subsets of sql?

547

---

What is the difference between clustered and non-clustered indexes?

601

---

What is form and report?

517

---

explain about mysql and its features. : Sql dba

543

---

Explain autonomous transaction.

632

---

Explain two easy sql optimizations.

602

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1063

---