/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

16 votes318 views3 answers
T-SQL Add Column
SQL
8 votes311 views2 answers
Update sql server from another table
SQL
0 vote295 views1 answer
Check if a column is a primary key in sql server
SQL
1 vote305 views1 answer
Mysql text to decimal
SQL
0 vote330 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
1 vote316 views1 answer
Db.Database.SqlQuery
SQL
-1 vote269 views3 answers
Check table exist postgresql
SQL
0 vote561 views1 answer
Power bi connect to postgresql
SQL
2 votes293 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote274 views1 answer
Jdbc sql connection string
SQL