Hi,
I am having a particular problem.
+-------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------+--------------+------+-----+---------+----------------+
| library_id | int(11) | | PRI | NULL | auto_increment |
| group_id | int(11) | YES | | NULL | |
| library_page_name | varchar(100) | YES | | NULL | |
| library_default | int(1) | YES | | NULL | |
| library_title | varchar(255) | YES | | NULL | |
| library_synopsis | text | YES | | NULL | |
| library_body | text | YES | | NULL | |
| language_id | int(3) | YES | | NULL | |
| file_id | int(11) | YES | | NULL | |
| user_id | int(11) | YES | | NULL | |
| library_allow_comments | int(1) | YES | | NULL | |
| library_create_datetime | datetime | YES | | NULL | |
| org_id | int(11) | YES | | NULL | |
+-------------------------+--------------+------+-----+---------+----------------+
I have duplicate entries in the above table what I want to get is the latest record of the duplicate entries. I tried the below
select max(library_id) as library_id,library_page_name,library_title from am_library where org_id=104 and group_id=99 group by library_page_name order by library_create_datetime desc;
Which i get
+------------+-------------------+---------------------------+
| library_id | library_page_name | library_title |
+------------+-------------------+---------------------------+
| 120 | SudPages | sud 1 |
| 102 | SudPage | Sudhakar's Wiki1 |
| 87 | MailList | mailing list requirements |
| 75 | TWAd | test wiki -Adrian |
| 73 | TestWikiRob | tesr3 |
| 69 | TestWiki | This is a test wiki |
| 67 | MentorWiki | Group Wiki Page |
+------------+-------------------+---------------------------+
in realiity the library_id120 actually belongs to the library_title sud 13.
How can i get this to work correctly I use
Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3