Hoe to make a selected column distinct in inner join

Hi,

May be we have to try another way for that. Actually why do you require such a data, with unique value for that particular column only?

yes Midhun you are right

but I am sorry there are still rows duplicated as I just copied and pasted your query

Yes Midhun

It still having repeated value

any new idea please

I appreciate your help

Thanks

Hi,

What is the result you getting while running below query? Is the videoname column having only distinct values?

Probably, if you want that kind of feature, please take a look at Partition Over .

https://msdn.microsoft.com/en-us/library/ms189461.aspx

thanks guys

still duplication in the column name I could not make it distinct with your code

Midhun T P

thanks

Hi Joma,

From the above query you provided, I think that this is not possible to achieve what you are trying. You may need to find some other way to address this issue. Assuming that "MID" is the primary key in the table, It is not possible to get distinct records for only a particular column in that table using above query.

Try below query. I'm not sure it solves your issue. Still you can give a try -

Basic query should be something like this.