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 does the base_object_type column shows in the user.triggers data dictionary view?

1008

---

Explain the working of foreign key?

1009

---

Why do we need unique key in a table?

913

---

What is the maximum size of sqlite database?

1067

---

What is difference between primary and secondary key?

989

---

How do I access sql anywhere database?

933

---

What is the purpose of a sql?

932

---

Can we commit in trigger?

936

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

957

---

How to write html code in pl sql?

1074

---

What is string join?

952

---

How do I view tables in sql developer?

893

---

How many types of index are there?

992

---

What operating systems are supported by oracle sql developer?

918

---

How do you get column names only for a table (sql server)?

1115

---