Last mysql

Mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

Mysql last year

SELECT * FROM my_table
WHERE YEAR(my_date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 YEAR));

How to fetch data from database without last column

SELECT lastName,firstName FROM Customer
       WHERE lastName LIKE "B%"
         AND city = "Indianapolis"
         AND (phone LIKE "%8%" OR fax LIKE "%8%")

Source: dummies.com

Last mysql

//returns the last value
SELECT working_hours FROM employee ORDER BY name DESC LIMIT 1;

Similar codes

7 votes177 views1 answer
Mysql unsafe update
SQL
0 vote205 views1 answer
Add week ending date sql server
SQL
0 vote144 views2 answers
Mysql unique two columns
SQL
0 vote166 views2 answers
List all constraints in postgres
SQL
8 votes199 views6 answers
Insert command in sql
SQL
1 vote199 views1 answer
Postgresql append array
SQL
0 vote147 views1 answer
Declare date variable sql
SQL
11 votes152 views1 answer
Get ddl materialized view oracle
SQL
0 vote177 views1 answer
Replace \n sql
SQL
16 votes178 views5 answers
Select last row in sql
SQL