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 latest version of sql?

1028

---

Does inner join return duplicate rows?

962

---

Which nosql database is best?

965

---

What is the difference between local variables and global variables?

1108

---

How does postgresql compare to "nosql"?

1018

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1169

---

Why use triggers in sql?

931

---

What is varray in pl sql?

1059

---

How to avoid duplicate records in a query?

987

---

How can we debug in PL/SQL?

1119

---

What does sql stand for?

975

---

What is normalisation and its types?

989

---

Can 2 queries be executed simultaneously in a distributed database system?

1132

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

1041

---

what is query cache in mysql? : Sql dba

1015

---