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 sql and mysql same?

0 Answers  

---

How are mysql timestamps seen to a user?

0 Answers  

---

Write a query to display current date and time?

0 Answers  

---

Why we use mongodb instead of mysql?

0 Answers  

---

What are the security alerts while using mysql?

0 Answers  

---

---

How important is to list the column names when doing an insert?

0 Answers  

---

Explain Access Control Lists.

0 Answers  

---

What is the use of innodb in mysql?

0 Answers  

---

What is the difference between the LIKE and REGEXP operators?

0 Answers  

---

What are mysql functions?

0 Answers  

---

What is the difference between CHAR and VARCHAR data types?

2 Answers   Ramco,

---

what is the advantage of stored procedures, triggers and indexing in mysql

1 Answers  

---