SQL - Or

MadD

Select * from table1 Where Position LIKE '%Str%' OR Company LIKE '%Str%' AND Status LIKE '2' ORDER BY Top,Date

为什么同一笔资料会出现两次?

hui_wooi

原帖由 MadD 于 13-2-2006 11:30 AM 发表
Select * from table1 Where Position LIKE '%Str%' OR Company LIKE '%Str%' AND Status LIKE '2' ORDER BY Top,Date

为什么同一笔资料会出现两次?

position's value and company's value 一样?

MadD

对, 我想只要 Position, Company 含$str 就列出来... 这种写法好像有问题

hui_wooi

原帖由 MadD 于 13-2-2006 02:14 PM 发表
对, 我想只要 Position, Company 含$str 就列出来... 这种写法好像有问题

不是很明白，你要什么。如果只是单纯的要一个资料，可以加入 DISTINCT

SELECT DISTINCT column_name FROM table_name

MadD

Select * from table1 Where (Position LIKE '%Str%' OR Company LIKE '%Str%') AND Status LIKE '2' ORDER BY Top,Date

hui_wooi

原帖由 MadD 于 14-2-2006 11:04 AM 发表
Select * from table1 Where (Position LIKE '%Str%' OR Company LIKE '%Str%') AND Status LIKE '2' ORDER BY Top,Date

Select distinct * from table1 Where (Position LIKE '%Str%' OR Company LIKE '%Str%') AND Status LIKE '2' ORDER BY Top,Date