top function - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

top function

Author

Topic

Janzi
Starting Member

1 Post

Posted - 2003-10-28 : 07:58:21

I joined together 2 tables.
Now I need to select top qstn_id which is sorted by answr_points.
No idea where and how to put top function?

use x
select
a.qstn_id,
s.tl_id ,
avg(a.answr_points) AS [ avg ]
from answers a join submitted_answers s
on a.answr_id = s.answr_id
group by s.tl_id, a.qstn_id
order by avg(a.answr_points)

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-10-28 : 08:16:32

Check BOL..


select  top 10 
a.qstn_id, 
s.tl_id ,
avg(a.answr_points) AS [ avg ]
from answers a join submitted_answers s 
on a.answr_id = s.answr_id 
group by s.tl_id, a.qstn_id 
order by avg(a.answr_points)

- Sekar

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources