/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

12 votes358 views1 answer
Psql drop column
SQL
0 vote389 views1 answer
Mysql faster delete
SQL
2 votes418 views1 answer
Mysql shell insert into
SQL
1 vote387 views2 answers
Extract weekday from date in sql
SQL
0 vote369 views1 answer
Como hacer una consulta en sql
SQL
0 vote399 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote441 views2 answers
Copy table in sql
SQL
29 votes367 views5 answers
Mysql show table structure
SQL
3 votes366 views1 answer
Force using index plsql
SQL
11 votes362 views1 answer
Mysql text type max length
SQL