Reputation: 151

Query for a latest updateTime for specific user

I have a table that a user placing bets on dUpdateTime.

DB Table ：

My Query :

select * from tbet where iUserKey=53298

How do I create a query that would give me the latest dUpdateTime with iUserKey = 53298.

Upvotes: 2

Answers (3)

Reputation: 125

Use max aggregate function to get the latest

SELECT MAX(dUpdateTime) FROM tbet WHERE iUserKey=53298

Upvotes: 1

Reputation: 2036

Try this:

select * from tbet where iUserKey=53298 order by dUpdateTime desc limit 1

Upvotes: 1

Reputation: 13237

Using MAX aggregate function

SELECT MAX(dUpdateTime) FROM tbet WHERE iUserKey = 53298

Upvotes: 5