/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 vote322 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote308 views1 answer
How to connect postgresql database with java
SQL
0 vote292 views2 answers
Show slave status mysql
SQL
0 vote314 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote330 views1 answer
Select milliseconds mysql
SQL
0 vote301 views4 answers
Database stuck at restoring state
SQL
0 vote314 views1 answer
TSQL convert csv to table
SQL
0 vote286 views1 answer
Alter session set nls_language french
SQL
1 vote293 views1 answer
Check message id sql server
SQL
24 votes301 views2 answers
Alter table delete column
SQL