mysql
sql
pdo

"exclude top and bottom n rows in sql" Code Answer

5

you can try this mate:

select * from numbers
where id not in (
    select id from numbers
    where val in (
        select max(val) from numbers
    ) or val in (
        select min(val) from numbers
    )
);
By mauscope on July 17 2022

Answers related to “exclude top and bottom n rows in sql”

Only authorized users can answer the Search term. Please sign in first, or register a free account.
Copyrights Full Stack User 2022 · Privacy · About Us · Terms of Use · Contact us · Write For Us