filmov
tv
SQL Queries||How to get first and last rows from the table?

Показать описание
select * from
(select Top 1* from emp Order By id asc)FirstRow
UNION ALL
select * from
(select Top 1* from emp Order by id desc)LastRow
(select Top 1* from emp Order By id asc)FirstRow
UNION ALL
select * from
(select Top 1* from emp Order by id desc)LastRow