Member Avatar for manojjena1982

I have a table name Project(id,projectid,date)
-----------------------------------------------------------
id | projectid | date
1 | 9 | 2009-02-03
2 | 9 | 2009-03-04
3 | 9 | 2009-04-05

i need a query which will return me the recent date of that project id.
query will return:
3 | 9| 2009-04-05

  • 2 Contributors
  • 1 Reply
  • 110 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by cgyrob
Member Avatar for cgyrob

Try something like

Select Top 1 from Project order by date desc
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.