Sign Up Login


  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

Question Posted / laxman


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

Post New Answer

More MySQL Interview Questions

What are different types of queries?

0 Answers  

What data type is money?

0 Answers  

What are the advantages of MySQL when compared with Oracle?

0 Answers  

What is mysql cursor?

0 Answers  

Is sql and mysql same?

0 Answers  

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

0 Answers  

Why use mysql procedures?

0 Answers  

Is postgresql better than mysql?

0 Answers  

Explain triggers and stored procedures?

0 Answers  

What are the objects can be created using CREATE statement?

0 Answers  

What is ibdata1?

0 Answers  

How to list or view all databases from the mysql server.

0 Answers  

For more MySQL Interview Questions Click Here
Categories