SELECT encounter_nr FROM care_encounter WHERE (care_encounter.encounter

how to find missing numbers between two order numbers;
and dates ?

Question Posted / laxman

1 Answers
6144 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a string in mysql?

909

How to get a version of mysql?

1048

What is the phantom problem?

1010

Write a query to stop mysql in unix

1056

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

951

How can you filter the duplicate data while retrieving records from the table?

902

How many TRIGGERS are allowed in MySql table?

1085

How do you flush privileges?

979

Why mysql is open source?

925

How do I optimize a selected query in mysql?

935

Is mysql a distributed database?

977

What is cast in mysql?

909

How can you take the backup and restore a mysql database using php?

963

What are slow queries?

909

How to change the database engine in mysql?

998