Answer Posted / s.dineshkumar

Select Top 1 Salary from (Select top 3 Salary from Employee
order by salary desc ) a

What are inner outer left and right joins in sql?

1002

---

what is the difference between a local and a global temporary table? : Sql dba

1052

---

Can you selectively load only those records that you need? : aql loader

1025

---

Is sql a backend language?

1077

---

Which sql statement is used to delete data from a database?

942

---

What is latest version of sql?

1031

---

Can a table contain multiple foreign key’s?

984

---

What are all ddl commands?

1068

---

what is a unique key ? : Sql dba

1080

---

What is the usage of nvl function?

1027

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1013

---

What are sql ddl commands?

1075

---

What is difference between sql and excel?

1072

---

What is PL/SQL Records?

1171

---

How do you modify a trigger?

915

---