SQL - How to get the First name,second name,Third name ?

GeekInterview.com

I am new, Sign me up!

GeekInterview.com > Interview Questions > Database > SQL

Go To First | Previous Question | Next Question

SQL | Question 130 of 139

Print

How to get the First name,second name,Third name ?

I have a column in a table with names.Now i want to select that names like first name,second and third.

I/p like this----- names
Chandu
Kannaka prasad
Rama krishna
Kiran kumar Kora
Balaji
Chandra sekhar potta
O/p I want------ Firstname Secondname Thirdname
chandu
kanaka Prasad
Rama Krishna
Kiran Kumar Kora
Balaji
Chandra Sekhar Potta

Total Answers and Comments: 5

Last Update: July 02, 2009 Asked by: chandra.pc

Sponsored Links

Best Rated Answer

—

Submitted by: seemu123

You can find it by

select 'Names'+' '+firstname+' '+secondname+' '+thirdname from tablename ...

Above answer was rated as good by the following members:
petrofahed

June 06, 2008 22:02:12

#1

Member Since: May 2008 Contribution: 10

RE: How to get the First name,second name,Third name ?

select firstname||' '||secondname||' '||thirdname from tablename;

Here "||" is the concatenation operatot so names and space is concatenated.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

June 10, 2008 14:02:12

#2

Member Since: June 2008 Contribution: 1

RE: How to get the First name,second name,Third name ?

A simple select of first name second name third name should display in that order since some of the rows have second and third name as null.

Is this answer useful? Yes | No

June 11, 2008 15:46:58

#3

Member Since: June 2008 Contribution: 1

RE: How to get the First name,second name,Third name ?

SELECT firstname secondname thirdname from the tablename

Is this answer useful? Yes | No

July 01, 2008 11:30:09

#4

Member Since: May 2008 Contribution: 15

RE: How to get the First name,second name,Third name ?

You can find it by

select 'Names'+' '+firstname+' '+secondname+' '+thirdname from tablename ...

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 02, 2009 09:11:33

#5

Member Since: January 2007 Contribution: 18

RE: How to get the First name,second name,Third name ?

select top 3 names from tablename

Try this u'll definately get the answer

Is this answer useful? Yes | No

Sponsored Links

Related Categories

—

Sponsored Links

About Us - Privacy Policy - Terms and Conditions - Contact - Ask Question - Propose Category - Site Updates

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved