1.
SELECT DISTINCT HW_ID FROM TB_USELINE WHERE
2.
((
'2010-01-11'
BETWEEN START_USE_DATE AND END_USE_DATE)OR
3.
(
'2010-01-15'
BETWEEN START_USE_DATE AND END_USE_DATE)OR
4.
(START_USE_DATE BETWEEN
'2010-01-11'
AND
'2010-01-15'
)OR
5.
(END_USE_DATE BETWEEN
'2010-01-11'
AND
'2010-01-15'
)
6.
)