how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  

---

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---

What are different types of sql?

0 Answers  

---

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

---

Can sql developer connect to db2?

0 Answers  

---

How to rename a table?

0 Answers  

---

Explain character-manipulation functions?

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,

---

What is multiple columns?

0 Answers  

---

Can we perform dml in function?

0 Answers  

---

What is Primary Key?

4 Answers   Ramco,

---

How do I write a cron which will run a sql query and mail the results to agroup?

0 Answers  

---