Answer Posted / vikram kumar

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Where can I learn sql for free?

933

---

Can we connect to postgresql using sql developer?

937

---

What is a data definition language?

1029

---

how to show all tables with 'mysql'? : Sql dba

1060

---

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 ?

954

---

Which is faster joins or subqueries?

931

---

What is the advantage of index in sql?

917

---

What is a null value?

1089

---

Is sql port 1433 encrypted?

974

---

What is the example of procedure?

877

---

How do I start sql profiler?

943

---

Is oracel sql developer written in java?

1060

---

What is the best free sql database?

1001

---

what happens if null values are involved in expressions? : Sql dba

1001

---

what is the use of double ampersand (&&) in sql queries?

1117

---