4.3.sql

USE Animal_Shelter; -- For SQL Server

-- Paging
SELECT TOP(3) *
FROM Animals;

SELECT	TOP(3) *
FROM	Animals
ORDER BY Primary_Color;

SELECT	*
FROM	Animals
ORDER BY Admission_Date DESC
OFFSET 0 ROWS FETCH NEXT 3 ROWS ONLY;


/* Most other DBMS

-- https://dbfiddle.uk/?rdbms=postgres_12&fiddle=f5a70243501d9d1146feabd907b95c77&hide=2

SELECT	*
FROM	Animals
ORDER BY Admission_Date DESC
LIMIT 3 OFFSET 0;
*/

-- Only one order by for presentation and paging
/* Nice to have, doesn't exist (yet)

SELECT	*
FROM	Animals
ORDER BY Species, Breed DESC
OFFSET 0 ROWS FETCH NEXT 3 ROWS ONLY USING Admission_Date DESC; /*Error*/
*/