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

1 vote134 views1 answer
Right outer vs left outer join
SQL
3 votes143 views2 answers
How to open postgresql in windows
SQL
4 votes126 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes135 views1 answer
How to insert string variable into sqlite database
SQL
1 vote139 views1 answer
Mysql show queries running
SQL
0 vote144 views1 answer
Mysql join column order By and group By
SQL
0 vote132 views1 answer
Mysql export search results
SQL
1 vote90 views1 answer
Ms sql - add one hour to time
SQL
2 votes163 views2 answers
Postgres set user as superuser
SQL
0 vote141 views1 answer
Sql put two columns into one
SQL