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

Difference between table function and pipelined function?

967

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1084

---

Can we join 3 tables in sql?

955

---

What is left join in sql?

1004

---

What is pl sql architecture?

922

---

What is sqlerrm?

882

---

How do you update a table in sql?

925

---

What is the difference between count 1 and count (*) in a sql query?

908

---

What are sql queries used for?

978

---

How to download oracle sql developer?

1056

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

899

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

953

---

what is a record in a database ? : Sql dba

995

---

What language is oracle sql developer?

938

---

How to avoid duplicate records in a query?

950

---