/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

13 votes155 views4 answers
Command line mysql import
SQL
0 vote149 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote179 views1 answer
Display all node label neo4j
SQL
0 vote143 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote146 views1 answer
Reona
SQL
0 vote139 views1 answer
T-SQL Never ending DELETE
SQL
0 vote147 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote131 views1 answer
Order by ip address sql
SQL
0 vote154 views1 answer
Count in sql and diff
SQL
1 vote165 views1 answer
Sql server set variable if exists
SQL