/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 vote107 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote119 views2 answers
Null value in column violates not-null constraint
SQL
0 vote102 views1 answer
Mysql convert charset
SQL
1 vote100 views1 answer
Create new table in SQL from old table with data
SQL
0 vote114 views1 answer
Second Step in installing SQL workbench
SQL
0 vote108 views4 answers
User defined function sql
SQL
18 votes103 views4 answers
Mysql current date between two dates
SQL
3 votes112 views2 answers
Postgres alter table owner
SQL
0 vote110 views1 answer
Delete record by id sql
SQL
0 vote109 views1 answer
Oracle webcenter content search enginer
SQL

Share