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

Write the alter statement to enable all the triggers on the t.students table.

1125

---

What is trigger and types?

1026

---

What is audit logout in sql profiler?

1026

---

What does the argument [or replace] do?

1083

---

Is sqlite free?

975

---

What's the procedure?

930

---

what are sequences

1749

---

What is a sql instance vs database?

1117

---

discuss about myisam index statistics collection. : Sql dba

952

---

How many joins can you have in sql?

938

---

Why do we use joins in sql?

971

---

What is normalisation and its types?

1005

---

What is the execution plan in sql?

1023

---

What is trigger in flip flop?

1007

---

What does over partition by mean in sql?

980

---