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

How to load data files into tables with 'mysqlimport'?

0 Answers  

---

What is difference between mongodb and mysql?

0 Answers  

---

I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks

2 Answers   Sun Life,

---

Which is best pdo or mysqli?

0 Answers  

---

How to get full name of monthname ?

4 Answers  

---

all the queries used in sql

0 Answers   TCS,

---

How to see table's field formats or description of table .

0 Answers  

---

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

0 Answers  

---

What are stored procedures and functions?

0 Answers  

---

What is username in mysql?

0 Answers  

---

SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,

---

how we will Show selected records sorted in an ascending (asc) or descending (desc).

0 Answers  

---