SQL Recipes (Beta II)
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers
to convert rows to column using SQL? to convert rows to column using SQL?

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 10-15-2006, 10:36 PM
anuj
 
Posts: n/a
Default MySQL dialect question:

to convert rows to column using SQL?

plese tell me how to convert the rows in to columns in postrgres........
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 12-26-2006, 10:17 PM
Juan carlos
 
Posts: n/a
Default T-SQL answer. Re: to convert rows to column using SQL?
SELECTCOLUMNNAME
FROM DBC.COLUMNS
ORDER BY COLUMNID;

* RESULT IN TERADATA SQL
ColumnName
SECT
GARA
BIEN

* I want obtained
SECT;GARA;BIEN;
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote
Reply

« How do I format mySQL date? | want to see all the queries for sql? »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Moderation Tools:



All times are GMT. The time now is 05:02 AM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2007 SQL Recipes

1 2 3 4 5 6 7