/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 vote127 views1 answer
Restore backup mysql .gz
SQL
1 vote142 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote117 views1 answer
Psql check if value in array
SQL
0 vote138 views4 answers
What is unique key in sql
SQL
0 vote165 views1 answer
Print hello world in plsql
SQL
3 votes122 views3 answers
C# sql select
SQL
1 vote81 views1 answer
Ms sql - add one hour to time
SQL
9 votes124 views4 answers
How to create new user and database postgresql in ubuntu
SQL
2 votes121 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
1 vote123 views1 answer
Best configuration for display table in sqlplus
SQL