Top 20 and bottom 20 values in 1 query

[gdev]

Hi

Is there a way to get the top 20 and bottom 20 values in 1 query without using a union query.
If so, please direct.

Thanks
Gwen

 

[SonOfEmidec1100]

I think UNION is the way to go, probably the only way.

(UNION not UNION ALL to avoid duplicates if the rows overlap.)

 

[gdev]

Your right
Thanks

 

[dhookom]

Consider a query of the Orders table in Northwind with the top 20 and bottom 20 OrderID values:

SELECT Orders.*
FROM Orders
WHERE Orders.OrderID In (SELECT TOP 20 OrderID FROM Orders ORDER BY OrderID) Or Orders.OrderID In (SELECT TOP 20 OrderID FROM Orders ORDER BY OrderID Desc);

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[gdev]

Perfect!
Love ya
Thanks very very much.


Gwen