get latest entry

homer.favenir · #1 (**permalink**) 12-09-08, 09:09

hi,
can anyone please help me how to get thy latest entry in my table
my query is

Code:

SELECT
a.transid,
a.artid,
b.remarks,
b.errID

FROM tbl_transactions as a
inner join tbl_errordetail as b on (b.transid = a.transid)

where a.artid = 123

i want to get the latest entry for b.errID without grouping by

thanks in advance

healdem · #2 (**permalink**) 12-09-08, 09:12

order by mycolumn DESC

homer.favenir · #3 (**permalink**) 12-09-08, 10:04

i only need the record that has the highest value

gvee · #4 (**permalink**) 12-09-08, 10:33

Limit 1 ?

galih · #5 (**permalink**) 01-04-09, 09:53

SELECT ...
ORDER BY b.errID DESC LIMIT 1

r937 · #6 (**permalink**) 01-04-09, 16:44

Code:

SELECT a.transid
     , a.artid
     , b.remarks
     , b.errID
  FROM tbl_transactions AS a
INNER 
  JOIN tbl_errordetail AS b 
    ON b.transid = a.transid
   AND b.errID =
       ( SELECT MAX(errID)
           FROM tbl_errordetail 
          WHERE transid = a.transid )
 WHERE a.artid = 123

mayz · #7 (**permalink**) 01-11-09, 00:33

You need to have an AutoID column that increaments automatically every time you add a new record.To select the most recent record,just write you SQl statement like this:

Select * from tablename order by AutoID desc
This will display the most recent records first
Hope this helps
AMY

r937 · #8 (**permalink**) 01-11-09, 00:37

mayz, you did not understand the question

and in any case getting the latest does not "require" an auto_increment

Internet Services

Web Development

Digital Marketing

Consumer Tech