Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

wie findet man via SQL in einer Tabelle den Datensatz mit dem jüngsten Datum? VG Franz

[Translation] how to find the data record with the most recent date in a table via SQL

asked 22 Jan '22, 06:54

Franz_Stf's gravatar image

Franz_Stf
157101115
accept rate: 0%

edited 24 Jan '22, 11:15

JBSchueler's gravatar image

JBSchueler
3.3k41564


Select top 1 * from MyTable order by MyColumn desc

permanent link

answered 22 Jan '22, 08:41

Volker%20Barth's gravatar image

Volker Barth
40.2k361549822
accept rate: 34%

Danke ! Hat geklappt ! VG Franz

(22 Jan '22, 10:29) Franz_Stf
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×46

question asked: 22 Jan '22, 06:54

question was seen: 550 times

last updated: 24 Jan '22, 11:15