/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

6 votes291 views2 answers
Join vs union
SQL
0 vote294 views1 answer
Sql server system messeges
SQL
0 vote287 views1 answer
Search In the Data using ObjectName
SQL
0 vote299 views1 answer
Sqlite3 update select
SQL
0 vote293 views1 answer
How convert into in in sql query
SQL
0 vote339 views1 answer
Postgres - Login and connect as default user
SQL
0 vote301 views1 answer
Create tables from xsd to sql server database c#
SQL
1 vote237 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote276 views1 answer
Select row from mysql where date more than 30 days
SQL
1 vote283 views1 answer
Postgres regex remove special characters
SQL