SQL - Very Basic

[Sketch]

I'm stupid, I don't know what I'm doing

I have 'updateTBL' < Table
With 2 Columns, A_COUNT, A_DATE. Very simple, the count is the primary key and increments by one each time a new date is added. How do I select the Max A_COUNT so that it will show the most recent date?

I tried;

SELECT A_DATE
FROM updateTBL
WHERE A_COUNT = MAX(A_COUNT);

Edit;
I didn't know how to delete the post, but I found out a solution

SELECT * FROM 
updateTBL 
WHERE 1
ORDER BY A_COUNT DESC
LIMIT 0,1

I guess it isn't the best way to do things, but hey it works

[DragonEye]

selecting the highest A_count is just

SELECT MAX(A_count) from updateTBL

it's quite easy, always use the easy solution

[Sketch]

Yer but I wanted to pull up date that date of the highest count, not the highest count itself...

[littleFella]

SELECT A_DATE
FROM updateTBL
WHERE A_COUNT = (SELECT MAX(A_COUNT) FROM updateTBL)

[Sketch]

Cheers littleFella, thats the one I shall use now ;-)