/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

12 votes179 views4 answers
SQL Where
SQL
3 votes169 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
25 votes182 views3 answers
How to use a database to see tables mysql
SQL
0 vote185 views1 answer
Select last N rows mysql
SQL
0 vote188 views3 answers
Between keyword sql
SQL
0 vote178 views3 answers
Sql all columns
SQL
0 vote187 views2 answers
Temp tables in sql server
SQL
0 vote190 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote177 views1 answer
Mysql identified by syntax error
SQL
0 vote203 views1 answer
Connect to ssms with python
SQL

Share