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.3k31564


Select top 1 * from MyTable order by MyColumn desc

permanent link

answered 22 Jan '22, 08:41

Volker%20Barth's gravatar image

Volker Barth
39.9k360547816
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: 459 times

last updated: 24 Jan '22, 11:15