top Image

top

question
barena avatar image
barena commented Default

How to find the average of top N rows based on date and location group in SQL?

grouping top avg order

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Kev Riley avatar image
Kev Riley answered Default

How to find avg of n number of rows by sample date?

top average

0 Likes

1Answer

0 Comments

question
Gelain avatar image
Gelain answered Default

Generate last row in date by ID

max top last

0 Likes

5Answers

1 Comment

question
GPO avatar image
GPO commented Default

Query to return the items that meet the criteria for being the latest.

sql query database top

0 Likes

1Answer

0 Comments

question
andreytk avatar image
andreytk answered Default

T-SQL query to list top n by department

top

This question has an accepted answer. Accepted

0 Likes

1Answer

4 Comments

question
Jeff O avatar image
Jeff O edited Default

Multiple select statements for a single table with union operator

select union top selectivity

This question has an accepted answer. Accepted

0 Likes

1Answer

1 Comment

question
dennisdg00 avatar image
dennisdg00 answered Default

TOP 10 RECORDS FOR SPECIFIC LOCATIONS BY TOTALS SALES

sql-server-2005 top rowcount

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
liton avatar image
liton commented Default

Top 10 records in one row

select top

This question has an accepted answer. Accepted

1 Like

1Answer

2 Comments

question
Grant Fritchey avatar image
Grant Fritchey converted answer to comment Default

top 3 from nested query

top

1 Like

1Answer

0 Comments

question
Kev Riley avatar image
Kev Riley commented Default

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

top outer-join optimizer scan-event

0 Likes

1Answer

7 Comments

question
KenJ avatar image
KenJ answered Default

Top In an Insert Statement

top

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
yaqubonnet avatar image
yaqubonnet edited Default

SQL Group by query - needs your attention

sql-server-2008 group-by top

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Christophe Vanderhaeghen avatar image
Christophe Vanderhaeghen asked Default

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

sql-server-2008 stored-procedures parameters top

This question has an accepted answer. Accepted

3 Likes

5Answers

0 Comments

question
Fatherjack avatar image
Fatherjack edited Default

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

t-sql top

2 Likes

4Answers

12 Comments

question
tony 1 1 avatar image
tony 1 1 edited Default

select only the last result

aggregates top

This question has an accepted answer. Accepted

0 Likes

2Answers

0 Comments

16 Posts
15 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.