/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 vote132 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
20 votes133 views2 answers
Counting in sql
SQL
10 votes164 views2 answers
Select nextval from sequence oracle
SQL
1 vote171 views1 answer
How to get alternate records from a table in sql
SQL
0 vote137 views1 answer
What is delimiter in mysql
SQL
4 votes149 views1 answer
Adding data to table in sql python
SQL
12 votes136 views2 answers
Insert multiple rows from another table sql
SQL
0 vote187 views1 answer
How to compile a function in oracle
SQL
2 votes123 views1 answer
Mysql auto increment jumping
SQL
0 vote128 views1 answer
Sql new line output
SQL