/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 vote303 views1 answer
Access refused mysql xampp server
SQL
13 votes323 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote336 views2 answers
Soql last year
SQL
0 vote333 views1 answer
C# add a textbox in mysql select
SQL
2 votes347 views5 answers
Install postgresql 10 centos 7
SQL
1 vote353 views1 answer
Liquibase alter column type / length
SQL
0 vote311 views1 answer
Mysql terminal list table
SQL
0 vote336 views2 answers
How to get the date from datetime in mysql
SQL
2 votes318 views3 answers
3 days back in sql server
SQL
0 vote331 views1 answer
Postgresql in vs any performance
SQL