Answer Posted / vinayak jamdar

Select top 1 empid,salary from (select distinct top 2
empid,salary from emp order by salary desc)a order by salary

Why do we use sqlite?

958

---

how to create a new view in mysql? : Sql dba

925

---

List the various privileges that a user can grant to another user?

1034

---

What is data manipulation language?

1175

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1033

---

What is consistency?

1108

---

What is restrict in sql?

1094

---

What is date functions?

1022

---

How do I add a primary key to a table?

1034

---

What are commit, rollback, and savepoint?

973

---

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

1017

---

How many sql statements are used?

1004

---

Explain what is sql?

1101

---

Cite the differences between execution of triggers and stored procedures?

1073

---

How can you load microsoft excel data into oracle? : aql loader

1159

---