• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 733
  • Last Modified:

need to create a criteria to filter by max value in query select

I tried using the max function but it's returning all the records screenshot
0
solarisinfosys
Asked:
solarisinfosys
  • 2
1 Solution
 
MINDSUPERBCommented:
You can use TOP 1 Query expression for that purpose. Below link will guide you how to do it.

http://www.blueclaw-db.com/accessquerysql/select_top.htm

Sincerely,
Ed
0
 
MINDSUPERBCommented:

I used the same expression with some of my applications and it worked perfectly. Here's a sample sql statement on it:

SELECT Top 1 Location.LocationID, Location.State, Location.City
FROM Location
ORDER BY Location.LocationID DESC;

The result display the Max value of  LocationID with its corresponding records.

Sincerely,
Ed

0
 
solarisinfosysAuthor Commented:
Thanks, it worked perfectly. Thanks for the example
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now