Answer / laxman

SELECT encounter_nr FROM care_encounter WHERE
(care_encounter.encounter_date BETWEEN '2008-03-01' AND
'2008-04-01') order by encounter_nr;
this will show 7000 rows in between date 2008-03-01 and
2008-04-01 ;
encounter_nr
200803010000
200803010001
200803010002
.
.
.
.
200803313229
in this i want to know which number is missing plz

What is the current version of mysql?

0 Answers  

---

what is the difference between between and in operators in mysql?

0 Answers  

---

Can you tell how to find the number of rows in a resultset using php?

0 Answers  

---

How large can a mysql table be?

0 Answers  

---

What is difference between mysql and mysql server?

0 Answers  

---

How do I start mysql server?

0 Answers  

---

What is mysql_pconnect?

0 Answers  

---

How to validate email addresses in mysql?

0 Answers  

---

What is bdb (berkeleydb)?

0 Answers  

---

What is sql in mysql?

0 Answers  

---

What are triggers in mysql?

0 Answers  

---

How can we know the number of days between two given dates using MySQL?

2 Answers   Base2 Infotech, Webworks,

---