How to exclude a column from SELECT query?

by

The Tutorial D relational database query language does allow a projection to be expressed in terms of the attributes to be removed using ALL BUT however there is no such equivalent syntax in SQL that allows you to do this. You need to explicitly list the specific ones that you want.

You could use a View if you commonly need this same set of columns.

More Related Contents:

  1. SQL Server dynamic PIVOT query?
  2. Is SELECT or INSERT in a function prone to race conditions?
  3. MySQL get row position in ORDER BY
  4. SQL Server Process Queue Race Condition
  5. Oracle SQL: Update a table with data from another table
  6. MySQL unknown column in ON clause
  7. SQL Server 2005 Pivot on Unknown Number of Columns
  8. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  9. Using Stored Procedure in Classical ASP .. execute and get results
  10. SQL – Subtracting a depleting value from rows
  11. Stored procedure or function expects parameter which is not supplied
  12. SQL Server Convert Varchar to Datetime
  13. OPTION (RECOMPILE) is Always Faster; Why?
  14. How do I implement pagination in SQL for MS Access?
  15. Remove numbers from string sql server
  16. What is the difference between SQL, PL-SQL and T-SQL?
  17. Export specific rows from a PostgreSQL table as INSERT SQL script
  18. What is the equivalent of ‘describe table’ in SQL Server?
  19. Create a SQL query to retrieve most recent records
  20. How do I edit a table in order to enable CASCADE DELETE?
  21. SQL to add column with default value – Access 2003
  22. Creating temporary database that works across maven test phases?
  23. Why can’t I seem to force Oracle 11g to consume more CPUs for a single SQL query
  24. Oracle (Old?) Joins – A tool/script for conversion?
  25. How to aggregate over rolling time window with groups in Spark
  26. Check if table exists and if it doesn’t exist, create it in SQL Server 2008
  27. Creating a custom ODBC driver
  28. sql select with column name like
  29. MySQL: Count records from one table and then update another
  30. Insert into from CTE

Leave a Comment