SQL query to display only most recent date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple programming question.

I work in a school and we have constant changes of students each week who
are paying weekly . I have to set up a query using SQL to search for

1) The date of only the most recent payment made.
2) If I want to display the students for a particular class for the coming
week how do I program that in?
 
1.
SELECT TOP 1 CurrentDate FROM SomeTable Order by CurrentDate;
(May have to order by date DESC)

2. not enough info on # 2.. would need to know how you're tables are set up..
 
Back
Top