1. Computing

Discuss in my forum

All too often, database tables contain cryptic column headings that don't make sense to users outside of a company's IT department. Fortunately, SQL provides a mechanism that allows us to change the headings displayed in query output for enhanced readability.

Read the full article: Renaming Columns in SQL Query Results
Comments
February 22, 2014 at 5:29 pm
(1) Srini says:

Hi Experts please look into the below Query.

ENAME DEPT
………………………………
abc 1
def 2
ghi 1
jkl 1
mno 2

I want to select ename and dept from emp table but the output should be like dept 1 replace with CSE and dept 2 replace with ECE.

Thanks & BestRegards
Srinivas

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.