/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 vote198 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
14 votes192 views4 answers
Sql compiler
SQL
0 vote188 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
1 vote220 views1 answer
Insert many to many sql
SQL
0 vote175 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote301 views1 answer
Postgres list all stored procedures query
SQL
0 vote187 views1 answer
Sql if else in select
SQL
2 votes181 views1 answer
Oracle drop table free up space
SQL
0 vote214 views1 answer
How to retrive the today date sql
SQL
0 vote3.7K views1 answer
PSQL use LIKE with timestamps
SQL