SQL Server

Understand the idea

This worked query uses a SQL Server table-value constructor so it is self-contained. TOP limits the ordered result. The same reporting idea in SQLite would use LIMIT at the end. A SQL Server connection and client are needed to execute this exact example; the browser editor intentionally stays SQLite rather than claiming to simulate every engine.

Where to try it

Use SQL Server for this example. It is shown for reading and local practice; the SQLite browser editor does not run this dialect or supply application-driver parameters. Follow the setup and explanation below in a disposable local environment.

SQLite sample data · MySQL / MariaDB sample data · See the sample tables

A worked example

SELECT TOP (2) name, price_cents
FROM (VALUES
  ('Pocket notebook', 250),
  ('Desk lamp', 1800),
  ('Canvas bag', 900)
) AS products(name, price_cents)
ORDER BY price_cents DESC, name;

Read the result

SQL Server returns Desk lamp and Canvas bag in descending price order. This standalone input avoids depending on a separate database import for the first dialect comparison.

Try one change

Rewrite this small example for SQLite using a CTE with VALUES and LIMIT 2. Compare the same two result rows.