The table has no ID, the date is contained in two columns

Question

I have a table in which a new record is added about once a second. The ID is missing from the table. The "Time" column shows the time in milliseconds, which is reset at the end of the day.

The "Date" column contains a date in the day-month-year format. What should I write in an SQL query to get the last added record every 1-2 seconds?

Please don't use images

Dale K
– Dale K

2025-04-23 19:44:24 +00:00
Commented Apr 23 at 19:44 — Dale K
– Dale K, Commented Apr 23 at 19:44

Muhammad Ahmed · Accepted Answer · 2025-04-23 18:29:30Z

2

For quick direct usage, you can use this simple SQL query that sorts by both the Date and Time columns in descending order, since Time resets daily.

SELECT * 
FROM your_table_name
ORDER BY Date DESC, Time DESC
LIMIT 1;

If you want to automate this, you can run this query inside your code using a loop or by defining sleep(1 or 2) intervals.

answered Apr 23 at 18:29

Muhammad Ahmed

745 bronze badges

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

Collectives™ on Stack Overflow

The table has no ID, the date is contained in two columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related