Christian

Site Sections

• Home
• Contact
• Syndication
• Login

Posts

391

Comments

137

Trackbacks

0

Nur den neuesten Datensatz ausgeben

Kann man mal wieder baruchen, nur den neuesten Eintrag einer Tabelle auswählen:

select max(confirmdate), orderaccount, confirmid, ...
from tabelle
group by
orderaccount, confirmid, ...

posted on Thursday, August 10, 2006 3:55 PM Print

Archives

• December, 2011 (1)
• November, 2011 (1)
• October, 2011 (2)
• September, 2011 (2)
• August, 2011 (2)
• July, 2011 (1)
• June, 2011 (2)
• May, 2011 (1)
• April, 2011 (3)
• March, 2011 (3)
• February, 2011 (3)
• January, 2011 (3)
• December, 2010 (4)
• November, 2010 (3)
• October, 2010 (4)
• September, 2010 (2)
• August, 2010 (3)
• July, 2010 (3)
• June, 2010 (2)
• May, 2010 (2)
• April, 2010 (3)
• March, 2010 (3)
• February, 2010 (2)
• January, 2010 (3)
• December, 2009 (3)
• November, 2009 (3)
• October, 2009 (3)
• September, 2009 (2)
• August, 2009 (3)
• July, 2009 (6)
• June, 2009 (5)
• May, 2009 (3)
• April, 2009 (3)
• March, 2009 (5)
• February, 2009 (4)
• January, 2009 (6)
• December, 2008 (15)
• November, 2008 (19)
• October, 2008 (5)
• September, 2008 (8)
• August, 2008 (8)
• July, 2008 (2)
• June, 2008 (2)
• May, 2008 (3)
• April, 2008 (4)
• March, 2008 (6)
• February, 2008 (3)
• January, 2008 (2)
• December, 2007 (1)
• November, 2007 (4)
• October, 2007 (6)
• September, 2007 (7)
• August, 2007 (5)
• July, 2007 (2)
• June, 2007 (9)
• May, 2007 (7)
• April, 2007 (3)
• March, 2007 (1)
• February, 2007 (4)
• January, 2007 (4)
• December, 2006 (5)
• November, 2006 (7)
• October, 2006 (4)
• September, 2006 (2)
• August, 2006 (4)
• July, 2006 (17)
• June, 2006 (21)
• May, 2006 (8)
• April, 2006 (16)
• March, 2006 (22)
• February, 2006 (15)
• January, 2006 (17)
• December, 2005 (10)
• November, 2005 (6)
• October, 2005 (2)
• September, 2005 (1)

Post Categories

• _Allgemein
• off topic
• Tools
• ADO.NET
• - Gridview
• - Allgemein
• - DataAdapter
• - DataReader
• - DataSet
• - DataTable
• ASP
• ASP.Net
• - AJAX
• - Controls
• - CSharp
• - DataGrid
• - DataList
• - MasterPage
• - Menu-Objekt
• - Paging
• - Repeater
• - RSS
• - Tipps
• - VB.NET
• - Web Forms
• Aspose
• - Cells
• CSharp
• Datenbank
• - Access
• - MS-SQL-Server
• - SQL
• - stored procedure
• Framework
• - Architektur
• - Tipps
• QualiSite
• - Allgemein
• - Layout
• - Navigation
• VM
• - Virtual PC
• - VMware
• Webdesign
• - AJAX
• - CSS
• - Javascript
• - Tools
• Impressum
• SharePoint (MOSS)
• - Allgemein
• - Coding tricks
• - Javascript
• - Excel Services
• - code snippets
• - Design
• Visual Studio
• - Add-In

test