Avatar of Luey
Flag for United States of America asked on

sql GROUP BY question

I cannot seem to get group by and order by to give the result I want.  The way i have it below it returns the group by correctly but the order by is wrong.  Kinda hard to explain but I am getting the first record from each cls_mem_id in the ascending order of the record in the database then the order by does order those records by cls_entry_date DESC.  What I need is to get the last record entered by each cls_mem_id then order those records by cls_entry_date DESC.

GROUP BY classifieds.cls_mem_id ORDER BY cls_entry_date DESC

Open in new window


Avatar of undefined
Last Comment
Guy Hengel [angelIII / a3]

8/22/2022 - Mon
Jerry Miller

If you only need the last entry for classifieds.cls_mem_id, in your query do a MAX(cls_entry_dat) as entry_date This will give the last ID entered, then your group by / order by should work as you desire.

I don't understand how to write it.
Jerry Miller

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck