/SQL/How to fetch data from database without last column

How to fetch data from database without last column

Mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

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

Similar codes

4 votes227 views2 answers
Oracle drop job
SQL
0 vote244 views1 answer
Postgresql like
SQL
3 votes247 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
8 votes228 views2 answers
Sqlsrv default port
SQL
0 vote224 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote192 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
1 vote245 views2 answers
This month mysql where
SQL
0 vote233 views1 answer
Acutal month year
SQL
0 vote251 views1 answer
How to make sure two tables have same exact data in sql
SQL
9 votes234 views5 answers
Laravel to sql
SQL