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

What is a mysql server?

0 Answers  

---

How to convert character strings to dates?

0 Answers  

---

What is mysql port?

0 Answers  

---

How do I run mysql without installing?

0 Answers  

---

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers   Afixi, GE,

---

How many tables will create when we create table, what are they?

2 Answers  

---

Does uninstalling mysql delete database?

0 Answers  

---

What is procedural api?

0 Answers  

---

what are the optimization techniques for Query optimization performance issues and faster execution of queries

2 Answers   Infosys, Sierra Atlantica,

---

How do I grant privileges to a user in mysql phpmyadmin?

0 Answers  

---

Is mariadb faster than mysql?

0 Answers  

---

What is full text indexing in mysql?

0 Answers  

---