Home > IT Answers > Development > Writing a specific query in SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 Writing a specific query in SQL Server 2005
Query, SQL Query, SQL Server 2005
I have a table called "ticketing" and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?

Software/Hardware used:
ASKED: July 15, 2008  8:28 PM
UPDATED: July 16, 2008  12:01 AM
RELATED QUESTIONS
Answer Wiki:
Assuming that your table has a date field you would write a statement like this. <pre>SELECT TOP (1) * FROM ticketing ORDER BY YourDateColumn DESC</pre>
Last Wiki Answer Submitted:  July 16, 2008  12:01 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.