/SQL/Select first and last row mysql

Select first and last row mysql

Select last row mysql

SELECT
  (SELECT * FROM tableName ORDER BY col1 LIMIT 1)        AS first,
  (SELECT * FROM tableName ORDER BY col1 DESC LIMIT 1)   AS last
;

4

Source: stackoverflow.com

Select first and last row mysql

(select *from DemoTable694 order by EmployeeId ASC LIMIT 1)
UNION
(select *from DemoTable694 order by EmployeeId DESC LIMIT 1);

0

Similar codes

0 vote265 views1 answer
SQL FROM-Klausel
SQL
0 vote262 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote268 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
6 votes255 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote259 views2 answers
Sql multiline comment
SQL
0 vote265 views2 answers
Oracle select
SQL
0 vote244 views1 answer
Declarative base sqlalchemy
SQL
13 votes240 views3 answers
Sql online code
SQL
0 vote242 views1 answer
Rollback to name in sql
SQL
34 votes271 views5 answers
Oracle alter table add column
SQL

Share