Interested to Buy Any Domain ? << Click Here >> for more details...
how to find missing numbers between two order numbers;
and dates ?
- 1 Answers
- 6058 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 |
Can we join 3 tables in mysql?
What is mysql and how it works?
What are the differences between char and nchar?
What is mysql default database?
If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?
Explain the different types of constraints?
What is a tinyint?
How do I create a database in mysql workbench?
How to store values to array from mysql database in php?
What is logs in mysql?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
Can we rollback truncate in mysql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
