Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Select 2 columns in one and combine them

Tags:

sql

select

sql-server-2005

Is it possible to select 2 columns in just one and combine them?

Example:

select something + somethingElse as onlyOneColumn from someTable

like image 218
Gondim Avatar asked Mar 17 '11 14:03

Gondim

People also ask

How do I combine data from multiple columns into one in SQL?

Select the same number of columns for each query. Corresponding columns must be the same general data type. Corresponding columns must all either allow null values or not allow null values. If you want to order the columns, specify a column number because the names of the columns you are merging are probably different.

How do I combine two columns into a single column in SQL?

SELECT COALESCE(column1,'') + COALESCE(column2,'') FROM table1. For this example, if column1 is NULL , then the results of column2 will show up, instead of a simple NULL .

1 Answers

(SELECT column1 as column FROM table ) UNION  (SELECT column2 as column FROM table )
like image 180
surya Avatar answered Sep 22 '22 14:09

surya
Sign in to Comment

Related questions

Update if different/changed
How to use SQL LIKE condition with multiple values in PostgreSQL?
SQL Server giving logins(users) db_owner access to database
Find duplicate records in a table using SQL Server
Java JDBC connection status
How to populate a table with a range of dates?
Insert if not exists Oracle
How to create an Oracle sequence starting with max value from a table?
Insert the same fixed value into multiple rows
A SQL Query to select a string between two known strings
How do I convert an int to a zero padded string in T-SQL?
updating columns with a sequence number mysql
SQL JPA - Multiple columns as primary key
SQL Insert Multiple Rows
How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
How to check if cursor exists (open status)
database/sql Tx - detecting Commit or Rollback
Determine Oracle null == null
MySQL function to find the number of working days between two dates
DB2 Query to retrieve all table names for a given schema

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!