Select Query() [sql server 2008]

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

Select Query() [sql server 2008]

Author

Topic

paramu
Posting Yak Master

151 Posts

Posted - 2009-12-29 : 03:50:38

I have a table itemmaster. Also having datas to "Unit_Measure" column..like...

UOM
---

NOS
BOX
LTR
NOS
NOS
BOX
ROLL
SET
ROLL
SET

I need to select from it without duplication like

NOS
BOX
LTR
ROLL
SET

so My Select Query is like...

Select Item_name,uom from itemmaster where ....?

Thanks For Ideas.

Paramu @ PARANTHAMAN

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-12-29 : 04:06:03

Hi

Try this


CREATE TABLE #TEMP (UOM VARCHAR(5))

INSERT INTO #TEMP
SELECT 'NOS' AS UOM  UNION ALL
SELECT 'BOX' UNION ALL
SELECT 'LTR' UNION ALL
SELECT 'NOS' UNION ALL
SELECT 'NOS' UNION ALL
SELECT 'BOX' UNION ALL
SELECT 'ROLL' UNION ALL
SELECT 'SET' UNION ALL
SELECT 'ROLL' UNION ALL
SELECT 'SET'



SELECT UOM FROM
(
SELECT * , ROW_NUMBER() OVER(PARTITION BY UOM ORDER BY UOM DESC) AS SEQ
FROM #TEMP
) T
WHERE T.SEQ = 1

-------------------------
R...

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-12-29 : 04:09:54

use distinct keyword..........

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2009-12-29 : 04:17:10

OR use Group by

select UOM from table_name group by UOM;

But,Distinct is Simple...

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

paramu
Posting Yak Master

151 Posts

Posted - 2009-12-29 : 04:21:41

Thanks For The Useful Tips. Very Nice Ideas.
Also "Very Happy New Year 2010"

Paramu @ PARANTHAMAN

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-12-29 : 04:21:56

Hi Paramu

Yes you can also use what senthil & Bklr said...


CREATE TABLE #TEMP (UOM VARCHAR(5))

INSERT INTO #TEMP
SELECT 'NOS' AS UOM  UNION ALL
SELECT 'BOX' UNION ALL
SELECT 'LTR' UNION ALL
SELECT 'NOS' UNION ALL
SELECT 'NOS' UNION ALL
SELECT 'BOX' UNION ALL
SELECT 'ROLL' UNION ALL
SELECT 'SET' UNION ALL
SELECT 'ROLL' UNION ALL
SELECT 'SET'

SELECT DISTINCT * FROM #TEMP

SELECT * FROM #TEMP GROUP BY UOM

-------------------------
R...

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-12-29 : 04:23:43

quote:
Originally posted by paramu

Thanks For The Useful Tips. Very Nice Ideas.
Also "Very Happy New Year 2010"

Paramu @ PARANTHAMAN

welcome and wish u happy new year too...........

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources