SQL Query

  • Thread starter Thread starter Michel Walsh
  • Start date Start date
M

Michel Walsh

Hi,


Well, accordingly to the data you supplied:

SELECT *
FROM myTable
WHERE [date]=( SELECT MAX([date])
FROM myTable )


Hoping it may help,
Vanderghast, Access MVP
 
Hi i have a table like this

mobile name date
------- ----- ----
9441212345 xyx 01/01/03
9441212345 xyx 01/01/03
9441212345 xyx 01/01/03
9441212345 abc 05/15/03
9441212345 abc 05/15/03
9441212345 abc 05/15/03
9441212345 pop 01/01/04
9441212345 pop 01/01/04
9441212345 pop 01/01/04

i want to select mobile nos for which date is latest. in this i want to
extract only the last 3 rows

How to do this.

thanks in advance.

Nandha.
 
Back
Top