 |  |  |  |  |  |  |  |
joining the table
Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
-----------------------------------------------------------
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
- Complex Query (MS SQL)
- using joining 'line' tables (MS SQL)
- using joining 'line' database tables in Dreamweaver (ASP)
- Confused? (MS SQL)
- MS Access 2000 - Inserting records in a new table by joining input from two tables (Visual Basic 4 / 5 / 6)
- Joining 4 or more tables (MySQL)
- How To Create Foreign Key (MySQL)
- Can anyone help me here! (Database Design)
Other Threads in the MS SQL Forum
- Previous Thread: How to combine multiple rows's column into one column
- Next Thread: String or binary data would be truncated.
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads