/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 vote184 views3 answers
Sql all columns
SQL
2 votes194 views1 answer
Mysql change data type of column
SQL
11 votes292 views2 answers
Sql between date range
SQL
2 votes214 views2 answers
How to rename column name in sql server using query
SQL
0 vote256 views1 answer
Sql decimal to 2 places
SQL
0 vote185 views1 answer
Set column width in sqlplus
SQL
0 vote208 views1 answer
Oracle lower in where clause
SQL
0 vote195 views1 answer
Sql missing values
SQL
0 vote192 views1 answer
Sql select upcoming birthdays
SQL
0 vote242 views1 answer
Import sql inside hide sql
SQL