Answer Posted / g.sivanagaraju

SELECT DISTINCT(A.SAL)
FROM EMP A
WHERE &N=(SELECT COUNT(DISTINCT(B.SAL))
FROM EMP B
WHERE A.SAL<=B.SAL);

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

507

---

Why query optimization is needed?

521

---

what does myisamchk do? : Sql dba

562

---

What are the benefits of stored procedures?

538

---

Can sql function call stored procedure?

562

---

---

what is error ora-03113: end-of-file on communication channel?

607

---

What has stored procedures in sql and how we can use it?

571

---

What is orm in sql?

541

---

What is sql profiler in oracle?

568

---

What is materialized view in sql?

469

---

What is sql analyzer?

547

---

What are the constraints available in sql?

583

---

How do you identify a primary key?

635

---

Is record in oracle pl sql?

535

---

What are reports usually used for?

570

---