explain mysql aggregate functions. : Sql dba

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

0 Answers  

---

Which are sql * plus commands?

0 Answers  

---

define sql update statement ? : Sql dba

0 Answers  

---

---

How do I run a sql query?

0 Answers  

---

write a query to find 4th max salary

7 Answers  

---

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

---

How delete a row in sql?

0 Answers  

---

what is meant by nl2br()? : Sql dba

0 Answers  

---

How can we schedule the procedure to run automatically ?

3 Answers  

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---