Pull latest data from database

Question

User-322746205 posted

Hi,

I want to pull the latest data from database by checking the latest start_time in my table Exam.

How to code it?

Thanks.

Answer 1

User-1316079624 posted

Hi,

Try something like this:

select MAX(start_time) as LatestDate from Exam

Hope this helps.

Answer 2

User-451195045 posted

hi you can try

select top(1) * from mytable order by start_time desc



hope will help you

Answer 3

User-322746205 posted

Thanks.. Its work!!