How to Exclude a Column from Select Query

How to select all the columns of a table except one column?

You can use this approach to get the data from all the columns except one:-

1. Insert all the data into a temporary table
2. Then drop the column which you dont want from the temporary table
3. Fetch the data from the temporary table(This will not contain the data of the removed column)
4. Drop the temporary table

Something like this:

SELECT * INTO #TemporaryTable FROM YourTableName

ALTER TABLE #TemporaryTable DROP COLUMN Columnwhichyouwanttoremove

SELECT * FROM #TemporaryTable 

DROP TABLE #TemporaryTable 

SQL - Exclude rows from SELECT statement if a certain column combination exists in that row

Since a row can only match one of those conditions at one time, you should be using OR:

SELECT COLUMN1, COLUMN2, COLUMN3
FROM YourTable
WHERE NOT (    
    ( COLUMN2 = 'A' AND COLUMN3 = 'B' )
     OR 
    ( COLUMN2= 'B' AND COLUMN3 = 'C' )
)

db<>fiddle here

Excluding some columns in a SELECT statement

The only way is to list all 9 columns.

Such as:

SELECT col1, col2, col3, col4, col5, col6, col7, col8, col9 FROM myTable

---

Related Topics