SQL Abfrage "Die letzten 50 Datensätze" einer MSSQL DB

[marabu]

Hallo André,

probiere es so:

SQL-Code:

SELECT 
  dbID, dbDateTime, dbinLastWritten, inindex, time_pre_low_plunger, 
  time_pre_high_plunger, Pre_diameter_A_plunger, pre_diameter_B_plunger,
  pre_boght_out_head_plung, respare1, respare2, respare3, respare4
  respare5, respare6, respare7, respare8
FROM Data159DB240 D
WHERE dbID IN (
  SELECT TOP 5 dbID FROM Data159DB240 ORDER BY dbID DESC
)
ORDER BY dbID

Grüße vom marabu