select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

Why do we need view in sql?

0 Answers  

---

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 ?

0 Answers  

---

what is self join and what is the requirement of self join? : Sql dba

0 Answers  

---

What is case function?

0 Answers  

---

What is string data type in sql?

0 Answers  

---

i have some prob lem to tell me about my self in interview first round ...

0 Answers  

---

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

---

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,

---

How does cross join work?

0 Answers  

---

What port does sql server use?

0 Answers  

---

How do I view output in sql developer?

0 Answers  

---