Christian

Site Sections

• Home
• Contact
• Syndication
• Login

Posts

242

Comments

66

Trackbacks

4

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

• 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 (2)
• 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 (5)
• 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 (2.0)
• - Atlas/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

test