How to update latest record using PostgreSQL?

Question

I have table attendance

    sno         |   OutTime
----------------+--------------
    1           |    2016-01-01
    2           |

How I get latest sno for passing my update query?
What is the select statement for getting latest sno?

update attendance set outtime=now() where sno=---?

Something like select max(sno) from attendance. I am not very good in postgre, check documentation for right sintax. — Thrash Bean
– Thrash Bean, Commented Apr 20, 2016 at 9:26

Patrick · Accepted Answer · 2016-04-20 09:26:51Z

2

Use a sub-query:

update attendance
set outtime = now()
where sno = (select max(sno) from attendance);

answered Apr 20, 2016 at 9:26

Patrick

33k7 gold badges73 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1