/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 vote384 views2 answers
Plpgsql
SQL
1 vote344 views1 answer
Decalre temp table sql
SQL
0 vote396 views1 answer
Postgres docs /copy metacomand
SQL
-1 vote419 views1 answer
How to Activate the database
SQL
0 vote349 views1 answer
Order by in codeigniter query builder
SQL
5 votes404 views1 answer
Oracle get ddl
SQL
0 vote374 views1 answer
Selecting duplicates
SQL
5 votes379 views2 answers
Oracle list columns
SQL
2 votes331 views1 answer
Match in sql server
SQL
2 votes409 views1 answer
Sql find not in list
SQL