[distinct] Forum Topics

Hi, I need to retrieve only 1 row for each 'message_id', with the Latest Date('sent_date'): ------------------------------------- message_id | sent_date | ------------------------------------- 805 | 2010-08-04 17:48:24 | <--- 805 | 2010-08-03 17:48:24 | 1007 | 2010-08-07 17:48:24 | 1007 | 2010-08-09 17:48:24 | <--- 1007 | 2010-08-08 17:48:24 | ------------------------------------- The …

Hello Experts, I have a dropdown list which is taking information from a database in which i used as per below SELECT DISTINCT * FROM [Devices] but still it shows multiple same values.I want that the values are unique.How should I fix it ? I already clicked -return only unique …

Dear All, I'm facing a problem when using DISTINCT in mysql. Please refer my database design below. id lang album singer title family writer song hits In my db i want distinct title and the id from the db. I'm trying the following code. But it only fetching the results …

Hello :D I am using the twitter API to perform a search for a certain author, and storing the results in a database so that I can perfrom an action on each entry. However, there are many duplicate results that have small differences at the beginning of the string or …

Hi, I have a dynamically generated sql query that is generated in VB6 and then passed on to SQL Server 2005. The query joins(inner join, left join, etc.) multiple tables. If I were to execute that query in Sql Server Management Studio, I would get something like this: TrayID| TrayID …

In datasource i have 5 columns and i want 3 columns data in particular dropdownlist having a distinct value... plz help

Hi All, I am writing a program to find the number between 1 and 100 that has the greatest number of distinct divisors. Below is my code for the same. It is returning an erroneous answer, i.e. 8 for greatest number of distinct divisors and 4 as the number for …

Hi, I want to only compare with a distinct value in a join across two tables. I am bulding a navigation, based on what gets returned (Based on how many "brand_id" is found in the join.) - I just only need to know if there is ONE brand_id of a …

hi, how can i select only unique string out of a series of iterating strings? for example, i have this folder which contains number of files with quite long names. i have used readdir() to find all the files. assume that the name of the file has an format. eg: …

1. I want to take unique district values from the below xml. How to do it in XPATH? 2. I want to take unique taluk values and district name="xyz". what is the xpath expression? XML structure: <?xml version="1.0" encoding="utf-8"?> <imageData> <row> <slno>1</slno> <sitecode>001</sitecode> <sitename>Mel Sittamur</sitename> <photono>001_001_001.jpg</photono> <photodate>07-09-2008</photodate> <district>Villupuram</district> <taluk>Senji</taluk> <monument><![CDATA[Jain …

Hi, Having some trouble getting it all together. I have a table in which i need to get Distinct names based on latest date. This is what the table looks like; Table Scores; [CODE] --------------------------------------------------------------------- | Name | Date | High Score | Medium Score | Low Score | --------------------------------------------------------------------- …

I have a somewhat complicated select query which returns, in part, the following resultset (as an example): [code=text] threadid views -------- ----- 1 5 1 5 2 10 3 15 4 10 [/code] If I were to do the following select: [code]COUNT (DISTINCT threadid), SUM (DISTINCT views)[/code] then it would …

Hi I am using the following join query to get a list of stores that have sold policies during the day. But I need it to be distinct [CODE] $Query = mysql_query("SELECT tblpolicies.StoreId , tblpolicies.DateReceived , DailyGroup.GroupName , DailyGroup.StoreName , DailyGroup.PortfolioName FROM tblpolicies LEFT OUTER JOIN (SELECT StoreId , GroupName, …

I'm trying to LINQ two tables based on a dynamic key. User can change key via a combo box. Key may be money, string, double, int, etc. Currently I'm getting the data just fine, but without filtering out the doubles. I can filter the double in VB, but it's slooooow. …

Hi all, I've been learning PHP and SQL slowly over the past couple of weeks for a project (so please be gentle!). I have a database, MEMBERS, as follows: [CODE] ID | Name | Job Title | Current Employer | State | Manager 1 | Joe Smith | Sample Title …

Hi All, I have a list of entries from users and want mysql to only display entries that are unique. The mysql statement is as follows [code] SELECT DISTINCT bids FROM `tbl_bids` ORDER BY `bids` ASC [/code] On running the query it is still displaying items that appear more than …

Hello all i am new to sql, iam having a requirement where i need to have a distinct value from the result lets say example, contacts table id name --- -------- 1 john 2 jason 3 mark address table id address conid -- ------ ----- 1 newlane1 1 2 newlane2 …