Select unique column in sql server

[Trini Alvarado]

Hello,
I am using sql server 2000 and I have a table with three columns name cone, ctwo and cthree. Now I would like to select unique column from it. For example if there are two columns of similar fields then I would like to fetch information these two columns but in a unique way. If you know how to do this then please let me know. Thank you for your help.

[Windowed]

Hello,
You can try the following query, though I am not sure that this is the one that your need

select colnm, datatyp, chmaxlength 
from infosch.columns
where tabnm = 'myTable'

[NetworkeR]

Hello,
See the below query this may help you

SELECT
frnm, lsnm, etc.,
MIN(date_column),
MAX(date_column)
FROM
table
GROUP BY
frnm, lsnm, etc.,
ORDER BY zip

[HardWeaR]

Hello,
Alternatively you can try the following sql query

select top 3 dv.[nm], dv.mnnum
from (
select [nm], max(number) as mnnum
from #test
group by [nm]
) dv
order by dv.mnnum desc

[SoftWore]

Hello,
I think this is the query which you are looking for

SELECT epnum, strdt, jobno
FROM tbnm as A
WHERE strdt =
(SELECT MAX(B.strdt)
FROM tbnm as B
WHERE A.epnum = B.epnum)

[NetworkeR]

Hello,
You can use the following

SELECT x.*, x.cy + ',' + x.state AS CityState
FROM zipcdtb x
INNER JOIN (SELECT cy, state, MAX(zip) AS zip
                     FROM zipcdtb b
                     GROUP BY cy, state
                   ) b
                   ON b.cy = x.cy and b.state = x.state and b.zip = x.zip

[HardWeaR]

Hi,
This is just a syntax but I think can help you

ALTER TABLE tble
   ALTER COLUMN mclm
       VARCHAR(50)
       NOT NULL
       DEFAULT 'some default value'