SQL - Select Last

SELECT column1, column2, ...
FROM table_name
WHERE condition
ORDER BY column_name DESC


Let's assume we have a "Tutorials" table with the following columns:

TutorialID (unique identifier for each tutorial)

Title (title of the tutorial)

IsFull (1 if the tutorial is complete, 0 if it's not complete)

Details (detailed content of the tutorial)

TutorialDate (date when the tutorial was created)

To select the last full detailed tutorial, we can use the following query:

SELECT TutorialID, Title, Details
FROM Tutorials
WHERE IsFull = 1
ORDER BY TutorialDate DESC


The SELECT statement specifies the columns you want to retrieve from the table. In this case, we're selecting TutorialID, Title, and Details.

The FROM clause indicates the table from which we want to retrieve data. In this case, it's the "Tutorials" table.

The WHERE clause is used to specify a condition to filter the rows. Here, we're checking if the IsFull column is equal to 1, which indicates a full tutorial.

The ORDER BY clause is used to sort the tutorials based on the TutorialDate column in descending order (DESC), so the most recent tutorial appears first.

Finally, the LIMIT 1 clause ensures that only one row is returned, which corresponds to the last full detailed tutorial.

By executing this query, you will retrieve the TutorialID, Title, and Details of the most recent full tutorial from the "Tutorials" table.