how to find missing numbers between two order numbers;
and dates ?
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
Is This Answer Correct ? | 0 Yes | 3 No |
What is the current version of mysql?
what is the difference between between and in operators in mysql?
Can you tell how to find the number of rows in a resultset using php?
How large can a mysql table be?
What is difference between mysql and mysql server?
How do I start mysql server?
What is mysql_pconnect?
How to validate email addresses in mysql?
What is bdb (berkeleydb)?
What is sql in mysql?
What are triggers in mysql?
How can we know the number of days between two given dates using MySQL?
2 Answers Base2 Infotech, Webworks,