Answer Posted / basavaraj yadwad

Let Table name : Employee
Let the columns: Employee_name, Salary

To find 101st row:

select * from (select * from Employee order by
emplayee_name) where rownum = 101

To find 4th highest salary

select * from (select * from Employee order by salary desc)
where rownum = 4


To find 5th highest salary

select * from (select * from Employee order by salary desc)
where rownum = 4


To find 1 to 10 highest salary

select * from (select * from Employee order by salary desc)
where rownum < 11

What is bitemporal narrowing?

1370

---

How do I count records in sql?

1054

---

What is union, minus and interact commands?

1366

---

Can you select everything, but 1 or 2 fields, without writer's cramp?

1040

---

Is and as keyword in pl sql?

1014

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2070

---

What is pl sql block structure?

1095

---

what happens if null values are involved in expressions? : Sql dba

1093

---

Explain raise_application_error.

1145

---

Explain the significance of the & and && operators in pl sql.

1049

---

What is the trigger in sql?

1004

---

What are hotfixes and patches?

987

---

What is the use of procedures?

1016

---

Does sql between include endpoints?

1061

---

How to create an array in pl/sql?

1123

---