/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

3 votes394 views1 answer
Mysql cli connect with password
SQL
3 votes354 views3 answers
Postgresql random number
SQL
21 votes360 views6 answers
Update sql
SQL
0 vote314 views1 answer
Uncomment listen_address=localhost
SQL
0 vote337 views1 answer
Full outer join in mariadb mysql
SQL
2 votes327 views1 answer
Set column to not null mysql
SQL
0 vote317 views1 answer
How to use lower case in mysql
SQL
1 vote343 views1 answer
Spark sql convert string to date
SQL
0 vote335 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote348 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL

Share