/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

4 votes150 views2 answers
How to insert ip address in mysql using php
SQL
0 vote141 views1 answer
Sql server express download
SQL
13 votes146 views1 answer
Select count of distinct values sql
SQL
0 vote142 views1 answer
How to export only procedures mysql
SQL
6 votes152 views2 answers
Where clause in sql
SQL
19 votes174 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
13 votes141 views4 answers
Mysql get last row
SQL
2 votes131 views3 answers
Mysql unix timestamp to date
SQL
0 vote193 views1 answer
Mysql show foreign keys column
SQL
11 votes228 views2 answers
Sql between date range
SQL