/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 vote137 views2 answers
How to combine diff colmun value using group by postgres
SQL
1 vote143 views1 answer
Sql current timestamp
SQL
0 vote150 views1 answer
How to find top 3 salary in sql
SQL
0 vote142 views1 answer
Oracle NLS_CHARACTERSET
SQL
11 votes148 views2 answers
How to import mysql database command line
SQL
0 vote133 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
3 votes132 views1 answer
Oracle APEX elapsed time
SQL
0 vote290 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote164 views1 answer
How much space does sql server take per row
SQL
0 vote140 views1 answer
Sql server express download
SQL

Share