mysql - Get latest rows from my sql database -
i have table there in rows there column called version. have 2 same entries 1 column abc(unique) in same rows. have 2 rows follows
id|name|version|unique_id ------------------------- 1 |abc |1 | 23 2 |abc1|2 |23 3 |xyz |1 |21 4 |tre |1 |20
i want result as
id|name|version|unique_id ------------------------- 2 |abc1|2 |23 3 |xyz |1 |21 4 |tre |1 |20
i have tried grouping unique_id, result follows
id|name|version|unique_id ------------------------- 1 |abc |1 | 23 3 |xyz |1 |21 4 |tre |1 |20
following query using
select * test group unique_id order version desc;
i want latest(top order desc) of each each rows. please help. how can achieve that.
how like
insert tbllogs (logorigin, logaction, loguser, logdate, logoutcome) values (:origin, :action, :user, :dt, :outcome)
use sub select determine id , max version number, join original table retrieve other values.
Comments
Post a Comment