/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

1 vote174 views1 answer
Float precision in psql
SQL
0 vote122 views1 answer
Check if due date is less than todays date sql
SQL
0 vote222 views1 answer
How to rename a database in tsql
SQL
0 vote168 views1 answer
Kill thread
SQL
0 vote168 views1 answer
Order by number of character in sql
SQL
2 votes144 views1 answer
Foreign key example in dbms
SQL
0 vote172 views1 answer
Sql delete caracter list
SQL
0 vote171 views1 answer
Mysql coonect sample code
SQL
0 vote162 views1 answer
SQL get max per id
SQL
0 vote162 views1 answer
Why mysql is used?
SQL