6 Answered Questions

[SOLVED] Retrieving n rows per group

6 Answered Questions

1 Answered Questions

[SOLVED] Select ONE most recent post for each author

5 Answered Questions

[SOLVED] How to select the first row of each group?

3 Answered Questions

2 Answered Questions

[SOLVED] How to select top 10 records from each category

2 Answered Questions

2 Answered Questions

2 Answered Questions

1 Answered Questions

1 Answered Questions

[SOLVED] Why am I getting different results from a query vs. a view

1 Answered Questions

1 Answered Questions

3 Answered Questions

[SOLVED] Remove duplicate values from query result

3 Answered Questions

[SOLVED] Select which has max date or latest date

1 Answered Questions

[SOLVED] Partition by ascending and descending performance

1 Answered Questions

1 Answered Questions

[SOLVED] SELECT LIMIT 1 per column value?

2 Answered Questions

[SOLVED] Get the last 5 distinct values for each ID

1 Answered Questions

[SOLVED] How to select the line with the max(date)?

2 Answered Questions

[SOLVED] Select most recent inspection

1 Answered Questions

2 Answered Questions

[SOLVED] How to get latest 2 records of each group

1 Answered Questions

3 Answered Questions

[SOLVED] Use GROUP BY and return more than 2 columns

2 Answered Questions

2 Answered Questions

3 Answered Questions