ÇóSQL(ËÍ·Ö£©

ID    DATE    CODE    TIME
=============================
A    1123    9      0015
A    1123    0      1535
A    1123    9      1620

A    1124    0      2330
A    1124    9      0010

Õë¶ÔÒÔÉÏÊó±êÇë½ÌÒ»¸öSQL£¬²éѯ³ö£º

11ÔÂ23ÈÕ 1.  CODE=0
        2.  CODE=9ÖÐTIME´óÓÚCODE=0ÖÐ×îСTIMEµÄËùÓмǼ

ÔÚÏߵȣ¡

---

ÏȽӷÖ.

---

SQL code:
1
SELECT * from TB WHERE CODE=0 AND DATE ='1123'

---

1.select * from table where code=0
2.select * from table where code=9 and time>(select min(time) from table where code=0)

---

1.select * from table where code=0 and data='1123'
2.select * from table where code=9 and data='1123' and time>(select min(time) from table where code=0 and data='1123')

---

SQL code:
-- =============================================
-- Author: T.O.P
-- Create date: 2009/11/26
-- Version: SQL SERVER 2005
-- ==============