Interested to Buy Any Domain ? << Click Here >> for more details...
how to find missing numbers between two order numbers;
and dates ?
- 1 Answers
- 6092 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
What is heap table in mysql?
What are the types of index?
What is mysql enterprise edition?
What is mysql community server?
What is mysql57?
List some mysql advantages and disadvantages?
What is localhost in mysql?
Can we write procedure in mysql?
What is truncate command?
What do you mean by % and _ in the LIKE statement?
What is action query?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
What does "i_am_a_dummy flag" do in mysql?
Why do gaps in sequences occur?
What are slow queries?
