SQL Server :: Get Distinct When Having Row Id
Oct 13, 2010
I have tableone:
rowid pid gid dis
1 1222 aa dd
2 1222 bb cc
3 1222 cc dd
4 1331 vv cc
5 1331 cc zz
6 1414 zz cc
5 1414 xx zz
I need get distinct pid with rowid together. select * distince pid from tableone However, I get error: select rowid, distinct pid from tableone? Is any way to work out this one?
View 4 Replies
Similar Messages:
Sep 30, 2010
I have the following table structure:
[code]....
The following query returns the default recordset:
[code]....
View 4 Replies
Feb 4, 2011
I have one table(tableName is getDetails and having three column ID, Name, City)
View 6 Replies
Apr 20, 2010
I would like to select a distinct query based on three fields and display the rest of the fields. For example,
I have firstname, lastname, address, city, state and zip, but I only want to use the distinct on these fields first and last name. However when i use the distinct function I get a distinct on all the selected rows. I just want to distinct firstname and lastname and display the other fields. for example,
Mary Smith New York
Mary Smithy New York
Mary Smith Maine
I would like the result to be:
Mary Smith New York
Mary Smithy New York
I don't care about Mary Smith Maine, because i am only using the distinct for "Mary Smith" firstname and last name and showing the city.
View 15 Replies
Jan 17, 2011
Here's my current table data.
AccountNumber Product
00505871 Product1
00505871 Product2
00503297 Product3
00900004 Product4
00505871 Product3
00514884 Product3
00503297 Product2
00505871 Product1
How can I achieve following result.
AccountNumber ProductString
00505871 Product1,Product2,Product3,
00503297 Product2,Product3
00900004 Product4
00514884 Product3
View 13 Replies
Jan 5, 2011
I need to bring the distinct result in third columnBelow one is my sample table
[Code]....
View 19 Replies
Mar 21, 2011
how can i use Distinct in my sql statement like that
SELECT
Distinct * from my_table ?? ? ? ?? ? ? ?
View 2 Replies
Sep 29, 2010
I have a one sql table, it contain 5 column id, ipaddress, status, datetime, value. I need to find distinct rows as per ipaddress column basic..
View 7 Replies
Mar 30, 2011
I have a table 'tbl' and a column 'col'. The elements are like 1,1,2,2,2,3,4,4. Now I want to show two columns one is the one will contain the distinct values from 'col' like 1,2,3,4.... and second will contain the count for each of them like for above case it will be 2,3,1,2.
View 1 Replies
Dec 8, 2010
I have the data below:
id locationid cookieid username IPAddress createdate
1 704 192.168.0.103 2010-12-08 18:11:24.423
2 704 192.168.0.103 2010-12-08 18:13:26.133
3 704 myname@hotmail.com 192.168.0.103 2010-12-08 18:13:47.710
4 704 myname@hotmail.com 192.168.0.103 2010-12-08 18:16:42.730
5 704 myname@hotmail.com 192.168.0.103 2010-12-08 18:17:00.433
6 704 myname@hotmail.com 192.168.0.103 2010-12-08 18:18:09.867
7 1504 myname@hotmail.com 192.168.0.103 2010-12-08 18:26:01.447
Now, I want to select all unique locationid's from a single username, its important that the results can be PAGED and SORTED, I now have:
SELECT * FROM (select ROW_NUMBER() OVER (ORDER BY createdate) as RowNum,
distinct(locationid), l.*
FROM location_views lv
INNER JOIN locations l on l.id=lv.locationid
where lv.username='myname@hotmail.com'
) as info
WHERE RowNum > 0 AND RowNum <= 100
But this throws the error: "Incorrect syntax near the keyword 'distinct'."
View 2 Replies
Jun 18, 2012
This is my last thread [URL] ....
This sp show duplicate row yet, what can i do?
View 1 Replies
Jan 21, 2011
I would like to know if there is a way that I can use DISTINCT on one column's values but need to show other columns where the value of the DISTINCT column is equal to another table's column
View 7 Replies
Dec 29, 2010
How can i select all columns of table but to distinct by one column? i am tryin to figure it out without success, i know how to make distinct (select distinct column from table, but i need all the values from the table and to distinct by Delcompany.
my line is:
[Code]....
View 13 Replies
Sep 25, 2010
I have a table with 2 columns that lookes something like this:
ChapterID | VersionNumber | VersionID |
1001 | 1 | 1004 |
1001 | 2 | 1005 |
1002 | 1 | 1006 |
1002 | 2 | 1007 |
1002 | 3 | 1008 |
1003 | 1 | 1009 |
1004 | 1 | 1010 |
what I wanna achieve is to have a statement that selects distinct uniqueid's from the chapterID field and with every duplicate I would like to have the record with the highest version number
Below is the result I would like to achieve:
ChapterID | VersionNumber | VersionID |
1001 | 2 | 1005 |
1002 | 3 | 1008 |
1003 | 1 | 1009 |
1004 | 1 | 1010 |
I have tried this statement:
Select Distinct ChapterID, max(VersionNumber) from Versions groupby ChapterID
and it works fine, but when I add the VersionID column like so:
Select Distinct ChapterID, VersionID, max(VersionNumber) from Versions group by ChapterID
it returns an error.
View 9 Replies
Feb 4, 2011
I have a page where I'm displaying all the different brand that I company stocks
For each distinct brand I need to display a count of the number of items with that particular brand
e.g.
brand name
number of products with that brand
brand name 2
number of products with that brand
brand name 3
number of products with that brand
View 2 Replies
Feb 26, 2011
how to write a select distinct column1 from another select ?
i mean SELECT distinct column1 from (SELECT column1,column2,column3 where column1 =1)
View 1 Replies
Feb 9, 2011
Having some troubles selecting distinct rows.
[Code]....
This is not giving me the wanted results.
Two models:
[code]....
Each ContentVersion is linked to Content through the ContentID.
I want to select all "Content" where UserID = X, then for each selected "Content" I want the latest "ContentVersion".
The return type should be of type <IQueryable>ContentVersion.
View 21 Replies
Nov 12, 2010
public static IEnumerable GetSollicitanten()
View 1 Replies
Oct 30, 2010
I am having difficulty in usint distinct with row filter, how to do this without using distinct.As i think distinct does not work with row filter.
Dim dsEName As DataSet = biz.GetEvent()
Dim dt As DataTable = dsEName.Tables(0)
Dim dv As New DataView(dsEName.Tables("dt"))
dv.RowFilter = "DISTINCT EventName "
Me.ddlEventName.DataSource = dv
Me.ddlEventName.DataTextField = "EventName"
Me.ddlEventName.DataValueField = "EventName"
Me.ddlEventName.DataBind()
View 1 Replies
Nov 24, 2010
1.Category:
CatID(Pkey),
CatName,
ParentCatId(Fkey)=> CatID is used as a ParentCatId
2.Comp_Cat:
CCID(Pkey),
CatID,(fkey),
CompID
In my stored Procedure I am passing PageNo,CompID.. My requirement is that One parent CatName is displayed Per page but only one time.
View 4 Replies
Nov 3, 2010
This is something I can easily do in SQL, but I'm pretty new to LINQ and haven't been able to find an answer online.
I need a LINQ query that returns two values; the first a distinct value and the second the count of the first value. This is filtered by a parameter. Here is my table:
[code]....
View 2 Replies
Jul 20, 2010
I am using C# + VSTS 2008 + .Net + ASP.Net + IIS 7.0 + ADO.Net + SQL Server 2008. I have a ADO.Net datatable object, and I want to filter out duplicate/similar records (in my specific rule to judge whether records are duplicate/similar -- if record/row has the same value for a string column, I will treat them as duplicate/similar records), and only keep one of such duplicate/similar records.
The output needs to be a datatable, may output the same datatable object if filter operation could be operated on the same datatable object.
What is the most efficient solution?
View 3 Replies
Feb 22, 2010
how to distinct arraylist value using c#?
View 10 Replies
Nov 9, 2010
I got a requirement from client that he wants to know distinct users information from sites and it sub sites those have access to site. There are separate groups for each subsite (contribute, approval and full access). From these all groups find distinct user information.
How can we do that using Object model?
View 1 Replies
Oct 27, 2010
I would like to get the distinct value form DataTabel using LINQ.
For example my sample table,
[code]....
1. How to get the distinct Country from Country you like column and the return records as Array or DataTable? (I want only India,USA,UK,Germany )
Is there any way to filter the record values using LINQ?
View 3 Replies
