/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 votes375 views2 answers
@sqlresultsetmapping
SQL
0 vote449 views1 answer
Mysql get nested records
SQL
0 vote424 views2 answers
Suse Linux restart MySQL
SQL
0 vote312 views1 answer
CREATE MULTIPLE FK
SQL
0 vote343 views1 answer
Sql not exists
SQL
0 vote338 views1 answer
Sql query to select records entered in last 24 hours
SQL
1 vote347 views2 answers
Check if word is in column sql
SQL
0 vote331 views1 answer
First mysql
SQL
0 vote330 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote357 views1 answer
Mysql loop through databases and execute query
SQL

Share