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

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

SQL code

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 )

SQL code

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)

SQL code

--方法一:
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)

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

SQL code

select distinct Name, Price, Time, Describ from P

SQL code

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