/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

1 vote199 views1 answer
Alter constraint postgres
SQL
0 vote138 views1 answer
Changing name of column and datatype in sql
SQL
13 votes121 views2 answers
Check if value is null mysql
SQL
1 vote83 views1 answer
Athena query timestamp greater than
SQL
0 vote155 views1 answer
Testing sql queries
SQL
0 vote125 views1 answer
2020 new year
SQL
0 vote178 views1 answer
Postgres list all stored procedures query
SQL
20 votes125 views2 answers
Counting in sql
SQL
0 vote131 views1 answer
Max mysql
SQL
15 votes132 views4 answers
Export mysql db using command line
SQL