/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 vote117 views1 answer
Oracle create index if not exists
SQL
0 vote100 views1 answer
Create date sql
SQL
0 vote117 views1 answer
How to map sql column to custom names
SQL
4 votes108 views1 answer
Restart for pg_hba.conf file
SQL
3 votes101 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote108 views2 answers
Mysql to python pandas
SQL
10 votes61 views2 answers
Django mysql
SQL
11 votes102 views2 answers
Oracle all source
SQL
7 votes118 views1 answer
Query postgres delete duplicates
SQL
1 vote121 views3 answers
Update from select sqlite
SQL