Interested to Buy Any Domain ? << Click Here >> for more details...
how to find missing numbers between two order numbers;
and dates ?
- 1 Answers
- 6057 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 delimiter in mysql trigger?
What is the maximum size of table in mysql?
What is the purpose of using a heap table?
What is slow query log in mysql?
What is 'mysqladmin' in mysql?
How do I copy a table in mysql?
Explain about the architecture of MYSQL?
What are the different data types in mysql?
What is the difference between timestamp and datetime in mysql?
Can mysql function return a table?
How to get a list of all tables in a database?
How to delete a database from mysql server.
What is meant by mysqli?
How do you restart mysql?
What are the mysql database files stored in system ?
