unable to display unique data

Question

0.00/5 (No votes)

See more:

i have a table market_place_design which has different market places and designs.
1 design exists in different market places.
I have another table temp which has only column design filled in it.
Now after joining the tables i am getting multiple data for a single design whereas i need only 1 top(1) to be precise.
But top 1 does not work if i am selecting multiple design.

Posted 12-May-13 22:19pm

AmrutaKanvinde

Add a Solution

Comments

Maciej Los 13-May-13 4:24am

What is your query?
Please, provide more details (example data), if you want our help.

AmrutaKanvinde 13-May-13 4:30am

"SELECT * from Tmp Tmp
inner JOIN MARKET_PLACE_DESIGN_RELATION MPDR ON MPDR.MARKET_PLACE_DESIGN=Tmp.MarketDesign "

table TMP contains only 4 rows and the result of this query should also return only 4 rows.
That is my requirement.however i am getting 12 because market_place_design_relation has for 1 design 3 rows(of different market places)

this is the main table
TransType VoucherNo ImportDuty DutyApp MarketDesign Design
LP NULL NULL NULL P06827-W NULL
LP NULL NULL NULL P12010-10KW NULL

and the result set with redundant values
CODE MARKET_PLACE_DESIGN
BuyUSA P06827-W
AmazonUS P06827-W
eBayUSA P06827-W
DD.COM P06827-W
BuyUSA P12010-10KW
AmazonUS P12010-10KW
eBayUSA P12010-10KW
DD.COM P12010-10KW

Distinct does not work.I tried already.

Thanks

Maciej Los 13-May-13 4:32am

and example data...

Use "Improve question" widget!

gvprabu 13-May-13 4:38am

you can use Group by and Having for this.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-05-12T22:35:00

Solution 1

Try this:

SQL

SELECT DISTINCT *
FROM Tmp Tmp inner JOIN MARKET_PLACE_DESIGN_RELATION MPDR ON MPDR.MARKET_PLACE_DESIGN=Tmp.MarketDesign

http://www.w3schools.com/sql/sql_distinct.asp[^]

Posted 12-May-13 22:35pm

Maciej Los