how to find missing numbers between two order numbers;
and dates ?
- 1 Answers
- 5374 Views
- I also Faced
- E-Mail Answers
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 |
What is prepare statement in mysql?
Which mysql function is used to concatenate string?
How to change the database engine in mysql?
Do while loop in mysql procedure?
Explain the difference between primary key and candidate key in mysql?
What is truncate in mysql?
What is the difference between heap table and temporary table?
What is the purpose of -> in the mysql terminal?
What is pragma exception?
Is mysql and sql are same?
How many ways to get the current time?
What are mysql functions?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
