How to rename column in query based on existing column

Question

So i want to create 3 columns in my query. One of those columns in the query needs to be renamed and use values from the Composer column. This is what i have so far:

CREATE VIEW [Multiple Composers] AS
SELECT Name, Composer FROM Track 
WHERE Composer LIKE '%/%'
AND Composer NOT LIKE 'AC/DC'

Not sure how to go about doing this and would appreciative some advice

As a follow up question. the third column was created but i'm not sure how i can apply a different where clause to the 3rd column. I wanted to have something like Where 3rd Column like '%, %' — TheFullMonty
– TheFullMonty, Commented May 18, 2016 at 2:44
third column is same as Composer you can put different clause on sam column or u have to create CTE or in line view ( sub query).. — sandeep rawat
– sandeep rawat, Commented May 18, 2016 at 3:00

Muhammad Abdul Arif Sarker · Accepted Answer · 2016-05-18 04:09:50Z

1

You can create new columns from existing columns using AS Clause, which allows you to specify an alias name for items. If you want to create conditions upon newly created column, use a temporary table.

with tmpTable as
(select name, composer, composer as newComposer from Track)
select name, composer, newComposer from tmpTable where composer like'%/%' and newComposer not like 'AC/DC';

answered May 18, 2016 at 4:09

Muhammad Abdul Arif Sarker

1,2194 gold badges15 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

TheFullMonty Over a year ago

Thanks. I executed this and the Composer And newComposer columns are identical. if i where to make the clause newComposer like '%, %' so that one columns shows foward slashes and one shows commas how would i go about doing that?

Muhammad Abdul Arif Sarker Over a year ago

In the where condition you can do anything with this newComposer column.Just change the condition.

Collectives™ on Stack Overflow

How to rename column in query based on existing column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related