/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 vote219 views1 answer
Sql script to remove default from column
SQL
0 vote210 views1 answer
If column value is null then in mysql
SQL
3 votes216 views3 answers
Mysql select table names
SQL
0 vote216 views2 answers
Sql stored procedure for access frontend
SQL
0 vote202 views1 answer
C# add a textbox in mysql select
SQL
2 votes196 views1 answer
Oracle cpu per session
SQL
11 votes253 views2 answers
Having keyword sql
SQL
0 vote237 views1 answer
Split first name and last name in sql
SQL
-1 vote193 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
8 votes249 views1 answer
Oracle add datafile to tablespace
SQL

Share