distinct

I am joining two tables (shipments and returns) and using group by to view totals for certain criteria. The two tables are related via shipment_id.…

I've a query like SELECT Id, Category, Title FROM articles WHERE 1 ORDER BY RAND() LIMIT 0,20 I've 20 categories and I want 1 random article per…

number | time 421112233444 | 1304010250 421112233444 | 1304272979 421001122333 | 1303563263 421112233444 | 1300217115 421001122333 | 1303649310 i…

I'm having trouble on generating a report in MySQL. I have this table: id date (yyyy-mm-dd) title I need to generate a report that throws how many…

I would like to take two columns of data in the same table, and return the unique records from both in an ordered list. I tried this: SELECT…

in my database I have a lot of entries that are very similar but not identical. For instance just two characters might be different such as: Row1:…

I want to find the distinct values of a varchar column in a super large MYSQL table(1 billion rows). I have the follow solution: 1. select…

I want to return all columns from a table, but only for the 'unique' or 'distinct' users. I want to grab all the distinct users from a table, but…

I need to generate query like this: SELECT DISTINCT ON (article.code) article.code, article.title First I try to make it via ORM distinct method and…

So I have this query, which pulls some features/materials for an item(shoes, generally). There are a lot of products, and thus a whole lot of…

I am getting all records like this in Zend: $table = new Model_Student_Object(); $select = $table->select(); echo $select->assemble();die();…

I have a table student like this id | name | zip 1 | abc | 1234 2 | xyz | 4321 3 | asd | 1234 I want to get all records but zip code should not be…

Hi, I have a table with day column like this: 2011-04-28, 2011-04-29 ... day count name surname 2011-04-28 8 titi tutu 2011-04-28 12 tutu toto…

Hi, I have the following two SQL tables for storing movie titles, and the dates I've seen them: CREATE TABLE movies ( id int(10) unsigned NOT NULL…

Hello, I have the following SQL query: SELECT c.comid, d.deid FROM dating_events d JOIN companions c ON d.userid = c.userid WHERE c.userid = 5 Which…

Hello, I am trying to make one statement to pull data from 3 related tables (as in they all share a common string index). I am having trouble…

I got a mysterious behaviour using DISTINCT on a MySQL table and can't figure it out: SELECT DISTINCT `deal_hash`,`city_name` FROM `a` WHERE…

I'm querying a bunch of cities from a zip-code table. I'd only like to grab results with an unique 'City'. (Lots of cities have multiple zips.) How…

I have a database table containing the following columns: id code value datetime timestamp. In this table the only unique values reside in id i.e.…

I have a table in which there is a bitwise column representing a list of statuses that can be attached to an entry. Each entry can have multiple…