求教SQL问题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

The following questions relate to a table below:
Stock_Ticker Analyst_Name Rating_Date Rating_Name
G Abramson 6/9/09 Hold
G Abramson 1/20/10 Sell
G Jones 12/5/09 Buy

Write an SQL query that would select the latest recommendation from each analyst for each stock.
Write an SQL query that would select the latest recommendation from each analyst for each stock as known on a specific date (e.g. 1/1/10).
Indicate problems that you see with this table design. How would you go about amending this data structure?

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：sql Recommend following questions Structure following problems specific design latest

select t.* from atst t
where t.rdate = (select max(rdate) from atst s group by name having s.name=t.name )

tested in oracel

多谢高手指点

有点看不明白

看的不是很明白

说明一下具体问题