Interested to Buy Any Domain ? << Click Here >> for more details...
how to find missing numbers between two order numbers;
and dates ?
- 1 Answers
- 6072 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 |
Do you need a license for mysql?
Explain the difference between procedure and function in mysql?
Is mysql distributed?
what is a cursor? : Mysql dba
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
How to add a new column to an existing table in mysql?
How big is a blob mysql?
What are the differences between char and nchar?
How many mysql connections can handle?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
Write a query to retrieve a hundred books starting from 20th.
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
-
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)
