/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 vote294 views1 answer
Sql how to replace full stop
SQL
0 vote271 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote306 views1 answer
Install mysql on bash
SQL
2 votes287 views2 answers
Mysql add hours to time field
SQL
0 vote272 views1 answer
Psql generate id in existing database
SQL
5 votes275 views6 answers
Sql foreign key
SQL
0 vote294 views1 answer
Sql with example
SQL
0 vote288 views1 answer
Copying query result to excel
SQL
0 vote259 views1 answer
Sql server remove 0 from left
SQL
0 vote279 views1 answer
Shortcut run sql pgadmin
SQL