CODEWITHSUNDEEP
sqloracle-database
E. Pluess
E. Pluess

Reputation: 5

Putting in additional, temporary text for results in SQL?

I'm trying to put in an additional word in a specific column of results for a query. I've got the query fine, but I can only find how to name a specific column within a table, and not the data shown within the column, and can't find the proper query online.

I want to get the data in the column to show '50 People', instead of just '50'.

For reference this is what I've got at the moment

SELECT *
FROM SCREEN
WHERE SCREENID IN ('S1','S3')
AND BRANCHID IN ('B1','B4')
AND SCREENCAPACITY NOT LIKE '%120%'

Upvotes: 0

Views: 121

Answers (1)

Esty
Esty

Reputation: 1912

Suppose Your SCREENID is 'S1', 'S3' and you want to show 'S1 Screen' and 'S3 Screen'.

SELECT CONCAT(SCREENID, ' Screen') AS RX
FROM SCREEN
WHERE SCREENID IN ('S1','S3')
AND BRANCHID IN ('B1','B4')
AND SCREENCAPACITY NOT LIKE '%120%'

Upvotes: 1

Related Questions