Answer Posted / hitesh

select top 1 salary from t1 where salary in(select top 2
salary from t1 order by salary desc)order by salary asc

How does rowid help in running a query faster?

1416

---

write an sql query to find names of employee start with 'a'? : Sql dba

1024

---

How many disk partitions should I have?

984

---

What version is sql?

1022

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1013

---

explain advantages of innodb over myisam. : Sql dba

1126

---

What is pl sql script?

1026

---

How to use sql statements in pl/sql?

1116

---

Who is the owner of mysql database?

1057

---

what are the type of locks ? : Sql dba

962

---

Enlist the data types that can be used in pl/sql?

1065

---

What is clustered index in sql?

1051

---

What is compound trigger?

1034

---

Why do we need cursor in pl sql?

1132

---

What are some emotional triggers?

981

---