Answer Posted / virendra

select ename, salary from emp where salary=(select top 1
salary from (select distinct top 3 salary from emp order
by salary desc) a order by salary)

Why is the cursor important?

975

---

What is meant by user defined function?

977

---

What is a composite primary key?

1030

---

Why is sql better than hql?

920

---

What is difference between table and view?

974

---

How do I copy a table in sql?

925

---

What is the execution plan in sql?

970

---

What is pl sql in dbms?

899

---

How many commands are there in sql?

970

---

Mention what does the hierarchical profiler does?

1020

---

What is structural independence and why is it important?

978

---

How does sql*loader handles newline characters in a record? : aql loader

984

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1031

---

Is inner join same as self join?

1059

---

How long will it take to learn pl sql?

888

---