/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

1 vote225 views3 answers
Showing all columns in an sqlite table
SQL
0 vote140 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote173 views1 answer
Sql query to find percentage of null values in a table
SQL
5 votes137 views2 answers
Postgre insert select
SQL
0 vote151 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
1 vote252 views1 answer
Mysql data from file
SQL
2 votes139 views1 answer
SELECT INTO
SQL
0 vote149 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote160 views2 answers
What is rownum in oracle
SQL
3 votes157 views1 answer
Increment integer in table sql
SQL

Share