Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 the advantages of MySQL when compared with Oracle?

0 Answers  

How to save images in MySQL?

2 Answers  

Which is faster innodb or myisam?

0 Answers  

What is DCL in MySQL?

1 Answers  

How do I find mysql version in mysql workbench?

0 Answers  

what is constraints?

0 Answers  

How many ways to get the current time?

0 Answers  

How many values can the SET function of MySQL take?

2 Answers   Creative Informatics,

What are the limitations of mysql?

0 Answers  

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

4 Answers   Aufait, CSS, Wipro,

What is mysql data directory? How to determine the location of the data directory?

0 Answers  

How can we convert between Unix & MySQL timestamps?

0 Answers  

For more MySQL Interview Questions Click Here
Categories