/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 vote211 views1 answer
Mysql select inside sum
SQL
-1 vote218 views1 answer
Mysql delete duplicate rows except one
SQL
1 vote192 views1 answer
Get last week data in mysql
SQL
0 vote149 views1 answer
How to set field to null in sql
SQL
0 vote196 views1 answer
Asp.net core sql server stored procedure
SQL
5 votes225 views4 answers
Mysql update column with value from another table
SQL
0 vote218 views1 answer
Delete a record from a table sqlite3
SQL
6 votes182 views2 answers
Mysql version check cmd
SQL
2 votes194 views1 answer
Sql column values comma separated
SQL
0 vote222 views1 answer
Select top values sql
SQL

Share