concatenate sql

Question

Write a query to concatenate staff id with first 3 characters from the staff name. Display with an alias as official_mail and order the results in ascending order.

my code:

select staff_id as official_mail
from Staff
order by official_mail;

how to write first 3 characters?

Which DBMS are you using? "SQL" is just a query language, not the name of a specific database product. Please add a tag for the database product you are using postgresql, oracle, sql-server, db2, ... — user330315
– user330315, Commented Mar 27, 2018 at 11:02

Jay Shankar Gupta · Accepted Answer · 2018-03-27 09:03:08Z

1

For MySQL/MSSQL

SELECT CONCAT(staff_id,SUBSTRING(staff_name,1,3)) AS official_mail
FROM Staff
ORDER BY official_mail;

Live Demo

http://sqlfiddle.com/#!9/f9c13b/1

edited Mar 27, 2018 at 9:03

answered Mar 27, 2018 at 8:49

Jay Shankar Gupta

6,1281 gold badge14 silver badges31 bronze badges

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

1 Comment

jarlh Over a year ago

Product specific answer to a question with no dbms specified. At least tell us which dbms this is for.

Collectives™ on Stack Overflow

concatenate sql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related