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

3 votes263 views2 answers
Oracle for loop
SQL
10 votes273 views1 answer
Create table oracle
SQL
0 vote284 views1 answer
Postgres statistics
SQL
5 votes330 views1 answer
Oracle source query
SQL
6 votes282 views1 answer
Postgres get size of database
SQL
16 votes293 views1 answer
Mysql reset auto increment value
SQL
1 vote280 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
1 vote295 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
1 vote274 views2 answers
Mssql show database size
SQL
0 vote325 views2 answers
Mysql cast to varchar
SQL