what are date and time data types in mysql? : Sql dba

0 Answers  

---

What is foreign key and example?

0 Answers  

---

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,

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

how to saw triggers output in pl/sql database?

1 Answers  

---

Can you sum a count in sql?

0 Answers  

---

What is exit statement?

0 Answers  

---

what is acid property in database? : Sql dba

0 Answers  

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

0 Answers  

---

Are sql views compiled?

1 Answers  

---