joining the table

Expand Post »

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

Similar Threads

How To Create Foreign Key in MySQL
Complex Query in MS SQL
using joining 'line' tables in MS SQL
using joining 'line' database tables in Dreamweaver in ASP
Confused? in MS SQL

manojjena1982

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

22 posts
since Jan 2009

Permalink

Jul 2nd, 2009

Re: joining the table

Try something like

SQL Syntax (Toggle Plain Text)
SELECT Top 1 FROM Project ORDER BY DATE desc
Select Top 1 from Project order by date desc

cgyrob

Reputation Points: 91

Solved Threads: 18

Junior Poster

Offline

125 posts
since Sep 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: How to combine multiple rows's column into one column

Next Thread in MS SQL Forum Timeline: String or binary data would be truncated.

DaniWeb Message

Cancel Changes

User Name
Password