/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 vote219 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
2 votes211 views1 answer
How to make insert script from table in SQL server
SQL
7 votes195 views1 answer
Append column sql
SQL
0 vote218 views1 answer
Oracle table privileges
SQL
0 vote153 views1 answer
Oracle sql developer script output limit
SQL
3 votes159 views1 answer
V$session not found in oracle
SQL
0 vote193 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote288 views2 answers
Disadvantages of stored procedures sql
SQL
6 votes193 views1 answer
Oracle rank() over (partition)
SQL
0 vote224 views1 answer
Including parameters in OPENQUERY
SQL