SELECT
*
FROM
表名称
WHERE
(
ID = '8E03B1A1A851430FBFC0FD71AF935D82'
AND CODE = '40L21241'
AND TM = TO_TIMESTAMP (
'2017-07-17 14:55:00.000000',
'YYYY-MM-DD HH24:MI:ssxff'
)
)
OR (
ID = '7DF5CF6B7D9A4E7BB9F2612433CE6513'
AND CODE = '40L21241'
AND TM = TO_TIMESTAMP (
'2017-07-17 15:00:00.000000',
'YYYY-MM-DD HH24:MI:ssxff'
)
)
*
FROM
表名称
WHERE
(
ID = '8E03B1A1A851430FBFC0FD71AF935D82'
AND CODE = '40L21241'
AND TM = TO_TIMESTAMP (
'2017-07-17 14:55:00.000000',
'YYYY-MM-DD HH24:MI:ssxff'
)
)
OR (
ID = '7DF5CF6B7D9A4E7BB9F2612433CE6513'
AND CODE = '40L21241'
AND TM = TO_TIMESTAMP (
'2017-07-17 15:00:00.000000',
'YYYY-MM-DD HH24:MI:ssxff'
)
)
本文提供了一个具体的SQL查询案例,展示了如何通过复杂的条件筛选特定记录。包括了使用AND连接多个条件、利用TO_TIMESTAMP函数精确匹配时间戳等技巧。

678

被折叠的 条评论
为什么被折叠?



