/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 vote314 views1 answer
Print hello world in plsql
SQL
0 vote235 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote248 views1 answer
SQL SERVER xquery count child nodes
SQL
1 vote206 views1 answer
Mysql show queries running
SQL
0 vote211 views1 answer
Describe in sqlite3
SQL
1 vote216 views1 answer
Sql random sampling per group
SQL
0 vote207 views1 answer
MySQL error code 2068
SQL
0 vote249 views1 answer
How to subquey to do not load in live database in
SQL
1 vote282 views1 answer
Connect to mysql database ubuntu
SQL
0 vote223 views1 answer
Sql select column name like from multiple tables
SQL