Questions in topic: top - SQL Server Q&A from the SQL Server Central community

x

login about faq Site discussion (meta-askssc)

Questions in topic: top

1

votes

1

answers

175

views

Top 10 records in one row

Jan 30 at 03:25 PM liton 570

select top

1

votes

1

answers

254

views

top 3 from nested query

Jun 21 '12 at 04:46 PM Grant Fritchey ♦♦ 61.5k

top

0

votes

1

answers

377

views

Why is index scan run on outer join when not using "SELECT TOP"

May 08 '12 at 05:16 PM Kev Riley ♦♦ 46k

outer-join top optimizer scan-event

0

votes

1

answers

287

views

Top In an Insert Statement

Apr 12 '12 at 08:37 PM KenJ 12.4k

top clause

0

votes

1

answers

402

views

SQL Group by query - needs your attention

Nov 21 '11 at 11:19 PM yaqubonnet 247

sql-server-2008 group-by top

3

votes

5

answers

1k

views

different ways to use parameterized TOP statement, but which one is the best?

Jan 07 '11 at 03:06 AM Christophe Vanderhaeghen 73

sql-server-2008 stored-procedures parameters top

2

votes

6

answers

1.7k

views

TOP N - in query bogs down SQL Server - WHY?

Oct 06 '10 at 02:15 PM Fatherjack ♦♦ 38.8k

t-sql top

0

votes

2

answers

982

views

select only the last result

May 18 '10 at 02:15 PM tony 1 1 5

aggregates top

1

votes

1

answers

3.5k

views

How To Select The Top Values From A Distinct List?

Nov 09 '09 at 03:44 PM Kristen ♦ 2.2k

sql-server-2000 aggregates top

9 questions

17answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags

sql-server-2008 × 1601
t-sql × 912
sql-server-2000 × 454
stored-procedures × 340
select × 87
parameters × 65
aggregates × 43
group-by × 32
outer-join × 10
top × 9
optimizer × 4
clause × 3
scan-event × 2

posts per page 15 30 50

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.