/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

0 vote261 views1 answer
Mysql remove bad character from all fields
SQL
-1 vote236 views1 answer
Mysql #1064 error
SQL
1 vote237 views1 answer
SQL date part only of datetime
SQL
0 vote235 views1 answer
Show size of all tables postgres
SQL
0 vote264 views1 answer
Hour and minute between two datatime sql
SQL
0 vote262 views2 answers
Plpgsql
SQL
-1 vote177 views1 answer
Mysql how to set update or create
SQL
4 votes236 views1 answer
Change nls_date_format
SQL
0 vote263 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote233 views1 answer
Sql make sure every user is unqiuew
SQL