Member Avatar for Dumb Fish

HI, I don't know how to get the lastest data form the database.

do anyone can give me some exmaples to see how to retrieve the latest 50 data.

  • 3 Contributors
  • 3 Replies
  • 123 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by jovillanuev

Dani AI

Generated

Asking for the "latest 50" means you must define what "latest" is: a timestamp (inserted/updated time) or an ever-increasing key. If the table lacks that, add a datetime column and populate it on insert/update. As hinted, a time column is the usual fix. ’s suggestion to look at the maximum date finds the newest timestamp value but does not return the latest rows themselves — to get rows you need ordering plus a limit.

Use ORDER BY with a limiting clause. For SQL Server the common patterns are:

SELECT TOP (50) *
FROM dbo.YourTable
ORDER BY CreatedAt DESC;

or, for paging (SQL Server 2012+):

SELECT *
FROM dbo.YourTable
ORDER BY CreatedAt DESC
OFFSET 0 ROWS
FETCH NEXT 50 ROWS ONLY;

See Microsoft docs for TOP and OFFSET-FETCH for details: TOP (Transact-SQL) and the ORDER BY/OFFSET-FETCH section in the SELECT docs.

A few practical tips and cautions:

  • Make the sort deterministic: add a tie-breaker like the primary key (for example ORDER BY CreatedAt DESC, Id DESC) so repeated timestamps give a stable order.
  • Index the date column (or make it the clustered index) for performance on large tables.
  • Prefer storing UTC (use appropriate datetime types such as datetime2 or datetimeoffset) to avoid timezone confusion.
  • If you need the latest row per group (for example per user), use a window function (ROW_NUMBER partitioning) to pick the most recent row in each group; see ROW_NUMBER (Transact-SQL).

If sample data or the current table schema is posted, a precise query and index recommendation can be shown.

Recommended Answers

All 3 Replies

Member Avatar for Eagletalon

Put a timestamp in the table that you update and select based on that?

Member Avatar for jovillanuev

Post your sample data.

Member Avatar for jovillanuev

Select Max(yourdate) from your Table.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.