Question

sql 获取一个表B中值，条件获取最大日期中的那条记录

price date Gname

A1001 2015/3/24 A清单

A1002 2015/4/25 A清单

A1003 2015/5/26 A清单

想获取price的值，条件date为最大日期，Gname为同一个。
SELECT PRICE from B WHERE date=MAX(date)
不知道要怎么写。。。求助

Answer 1

1.  select top 1 price from B order by date  desc

2. select price from b where date=(select max(date) from  b)