Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to select column name

Author  Topic 

born2acheive
Yak Posting Veteran

65 Posts

Posted - 2006-10-06 : 22:51:26
hi,i have

q_no process mech instru comm budget

q3 malu sasi malu sasi malu
q5 sasi malu sasi malu sasi

i want to select all the column names where q_no=q3

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-10-06 : 22:54:06
[code]
select *
from table
where q_no = 'q3'
[/code]


KH

Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-10-06 : 23:19:26
You may need to Learn SQL:
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp



CODO ERGO SUM
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-10-06 : 23:24:02
quote:
You may need to Learn SQL




KH

Go to Top of Page

rammohan
Posting Yak Master

212 Posts

Posted - 2006-10-07 : 05:15:20
learn SQL first

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

Go to Top of Page
   

- Advertisement -