Interested to Buy Any Domain ? << Click Here >> for more details...
how to find missing numbers between two order numbers;
and dates ?
- 1 Answers
- 6133 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
Why mysql is open source?
Is mysql a nosql database?
what is database black box testing? : Mysql dba
In which format data is stored in mysql database?
What is pdo in mysql?
How do you create a primary key?
What is use of mysql?
How to return query output in html format?
Is mysql a programming language?
How many threads can mysql handle?
How do I uninstall mysql connector?
What is view? How can you create and drop view in mysql?
How many ways to get the current time?
What is mysqlcheck do?
How we can create index in mysql?
