Selecting Top 10 Values

[bwalk037]

Hello,

I have the following union query, is there away for this query to output only the Top 10 values?


select * from [Highest Impacting AR Reserve Invoices]
UNION select * from [Highest Impacting FM Reserve Invoices];

 

[pbaldy]

I suspect you'll have to base a second query on this one, and use TOP there. That's based on the assumption that you don't know which of those will produce the top 10.

 

[bwalk037]

I figured making a separate query would be the easiest way to get the top 10 values but, how do I specify which field I want the query to use to determine the top 10 values?

 

[pbaldy]

It will pull the top values based on the sorting, so within your second query, specify the field or fields you want the sorting on. Presuming you want the largest values as your top values, you'd sort descending.