sql查询问题

Question

详细情况是这样的，有3个列分别为，科室，时间，内容。当我查找特定时间的内容时，查询的结果就会隐藏一个时间相同，可以也相同的一个行，怎么才能叫隐藏的哪个相同科室的哪个行也显示出来呢，望高手帮帮小弟，在此不胜感激

Answer 1

？？？没看懂难道用 select * from tablea where time1= mytime 能隐藏记录？

Answer 2

select * from table where 时间 = your_time ;
会返回所有与your_time的行，C#中用一个DataTable接受，遍历这个DataTable就得到所有返回的结果。（或者SqlDataReader读取)

Answer 3

不可能隐藏啊，除非你用了distinct

Answer 4

原始数据
ks1 2008-08-08 00:00:00.000 aaa
ks1 2008-08-08 00:00:00.000 aaa
ks1 2008-08-09 00:00:00.000 aaa
ks3 2008-08-08 00:00:00.000 aaa
ks4 2008-08-08 00:00:00.000 aaa
ks5 2008-08-08 00:00:00.000 aaa
ks2 2008-08-08 00:00:00.000 aaa
ks2 2008-08-09 00:00:00.000 aaa
ks3 2008-08-12 00:00:00.000 aaa
ks4 2008-08-08 00:00:00.000 aaa
ks7 2008-08-11 00:00:00.000 aaa
ks9 2008-08-28 00:00:00.000 aaause master
go
create table test
(
  ks varchar(10),
  sj datetime,
  content varchar(10)
)
go
insert into test values('ks1','2008-8-8','aaa')
insert into test values('ks1','2008-8-8','aaa')
insert into test values('ks1','2008-8-9','aaa')
insert into test values('ks3','2008-8-8','aaa')
insert into test values('ks4','2008-8-8','aaa')
insert into test values('ks5','2008-8-8','aaa')
insert into test values('ks2','2008-8-8','aaa')
insert into test values('ks2','2008-8-9','aaa')
insert into test values('ks3','2008-8-12','aaa')
insert into test values('ks4','2008-8-8','aaa')
insert into test values('ks7','2008-8-11','aaa')
insert into test values('ks9','2008-8-28','aaa')
go
select * from test
go
select distinct * from test where sj='2008-8-8'
go
结果隐藏了相同时间，相同科室的行，是因为你使用了distinct
ks1 2008-08-08 00:00:00.000 aaa
ks2 2008-08-08 00:00:00.000 aaa
ks3 2008-08-08 00:00:00.000 aaa
ks4 2008-08-08 00:00:00.000 aaa
ks5 2008-08-08 00:00:00.000 aaa
select * from test where sj='2008-8-8'
go结果没有隐藏，不要使用distinct
ks1 2008-08-08 00:00:00.000 aaa
ks1 2008-08-08 00:00:00.000 aaa
ks3 2008-08-08 00:00:00.000 aaa
ks4 2008-08-08 00:00:00.000 aaa
ks5 2008-08-08 00:00:00.000 aaa
ks2 2008-08-08 00:00:00.000 aaa
ks4 2008-08-08 00:00:00.000 aaa