sql语句查询筛选重复值问题

[Fs_2011]

数据表P 中有字段Name Price Time Describ Id
表中有记录Name Price Time Describ 全部相同，只Id不同，
想筛选出其中一条记录，无论是哪一条，只要查询结果不重复就行

[快溜]

select * from P t
 where not exists(select 1 from P where Name=t.Name and Price=t.Price 
                     and [Time]=t.[Time] and Describ=t.Describ and id<t.Describ )

[--小F--]

select
  *
from
  p t
where
  id=(select max(id) from p where  Name=t.Name and Price=t.Price and [Time]=t.[Time] and Describ=t.Describ)

[pengxuan]

--方法一:
select * from tb a where id=(select max(id) from tb where Name=a.Name and price=a.price and Time=a.time and Describ=a.Describ)
--方法二
select * fromt b a where not exists(select 1 from tb where Name=a.Name and price=a.price and Time=a.time and Describ=a.Describ and id>a.id)

[Fs_2011]

我的id是uniqueidentifier，不能用max和min函数的

[-晴天]

select distinct Name, Price, Time, Describ from P

[--小F--]

select
  *
from
  (select px=row_number()over(partition by Name ,Price ,Time ,Describ order by getdate()),* from tb)t
where
  px=1

[rjthinking]

select * from table where id in (select max(id) from table group by [Name], [Price], [Time] ,[Describ])

[勿勿]

distinct

[q465897859]

+1[Quote=引用 6 楼 fredrickhu 的回复:]
SQL code

select
*
from
(select px=row_number()over(partition by Name ,Price ,Time ,Describ order by getdate()),* from tb)t
where
px=1
[/Quote]

[只记今朝笑]

好简单的问题啊！可能是没明白你的意思吧。
方法1：
SELECT Top 1 Name,Price,Time,Describ FROM p Order By id DESC
方法2：
SELECT Distinct Name,Price,Time,Describ FROM p

[JS]

没时间一直上外网在守在这里解决问题和借鉴高人的方法 悲催啊 fredrickhu和qianjin036a、ssp2009都是大拿啊 我进的每个帖子几乎都有他们 天天盘踞在这里为人排忧解难 真是热心肠的好人啊