suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

What is the left table in sql?

0 Answers  

---

What is the maximum number of rows in sql table?

0 Answers  

---

What do you mean by stored procedures?

0 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

what eliminate duplicate without using roenum and not

5 Answers   Matrix,

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

How can a function retun more than one value in oracle with proper example?

0 Answers  

---

what is not null constraint? : Sql dba

0 Answers  

---

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

---

Can you load data into multiple tables at once? : aql loader

0 Answers  

---

Explain the uses of database trigger.

0 Answers  

---