oracle sql concat query title -


for course of databases got home sql excercises. 1 of them result this:

who earns _____________________ mr martin earns 1250 month 

now got way select right data in:

select 'mr ' || ename || ' earns ' || sal || ' month ' emp ename = 'martin'; 

but can't find how put title on top of query? can me on that?

as "who earns what"

like this:

select 'mr ' || ename || ' earns ' || sal || ' month '  "who earns what" emp ename = 'martin'; 

Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -