Topic profile page for Distinct.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Distinct.
Topic "Distinct" was discussed 0 times on 0 sites in last 3 months
Started 23 hours, 12 minutes ago (2009-12-16 22:18:00)
by Gdr
Islam Preach Cruelty and has always been threat to civilised societies While Hinduism is broad minded Can these Two Distinct Civilizations ie Hinduism and Islam Co - Exist
Started 1 day, 6 hours ago (2009-12-16 14:47:00)
by ozzii
Hi, Does any one know how to do average of a column but only for distinct records. I know you can use the distinct clause but I want the distinct not on the aggregate but on another column. EG. I have a table called sales and it has a column called sales_amt and another column called reference. It may look like this: Code: reference sales_amnt 1 100 1...
Started 1 day, 14 hours ago (2009-12-16 06:52:00)
by Sharfudeen
I have three tables MainTable, CatTable1 and CatTable2. ----MainTable----- Cat1_Code_Column Cat2_Code_Column UPHOLSTERY SOUTHERN LAMPS ANTHONYS LAMPS ANTHONYS LAMPS ANTHONYS UPHOLSTERY AICO - UPH From MainTable Cat1_Column I get distinct rows and ...
Started 1 day, 20 hours ago (2009-12-16 01:11:00)
by user598986
Hi, Need help in sloving the desired output: I have table TABLEA where the records lik: CODE NO A 1 A 2 A 3 B 1 B 2 C 1 C 2 I want the output as : A 1 B 1 C 1 I ahve used : SELECT DISTINCT CODE,NO FROM TABLEA GROUP BY NO: but i could not get the output as ...
Started 2 days, 1 hour ago (2009-12-15 19:31:00)
by rhst11
> Can an expert help me with this query? I'm new to SQL I need to find the value in a calculation Number of booking (sum(case when T1.str_contact_type ='In person' then 1 else 0 end)) divide by number of distinct clients with a condition: T1.str_contact_type ='In person' Declare @startdate datetime Declare @enddate datetime set @startdate='2009-03-01 00:00:00' set...
Started 2 days, 6 hours ago (2009-12-15 15:27:00)
by pleashelp
Using CR XIR2 with a SQL database. I have grouped my report by a date field by the week. I am displaying a distinct count of persons by the week. This part works fine of course. Now I want to add those weekly counts. I don't just want a distinct count of the month since that gives me a different number. I would like to actually add each weekly count to get a monthly total. Is there a way to ...
Started 5 days, 20 hours ago (2009-12-12 01:16:00)
by ironorehopper
Virology. 2009 Dec 5. [Epub ahead of print] Monoclonal antibodies in man that neutralized H3N2 influenza viruses were classified into three groups with distinct strain specificity: 1968-1973, 1977-1993 and 1997-2003. Okada J, Ohshima N, Kubota-Koketsu R, Ota S, Takase W, Azuma M, Iba Y, Nakagawa N, Yoshikawa T, Nakajima Y, Ishikawa T, Asano Y, Okuno Y, Kurosawa Y. - Division of ...
Started 2 days, 13 hours ago (2009-12-15 07:34:00)
by chinarose2009
Hi, all, from now on, I need to use crystal report, and now I have met one question about the parameter, how could show one parameter who maybe list of distinct one column value in database. Your advice or solution is really appreciated. Thanks a lot
Started 1 week, 1 day ago (2009-12-09 12:52:00)
by mpholt
I have a query which produces duplicate results often times in a column, and I am trying to figure out how to only return distinct values for a specific column. The columns in my query are below: Query A ID Name Category Value Category Term Both Category Value and Category Term can contain multiple values for the same ID/Name pair. An example execution is below: ID - ...
Started 1 week ago (2009-12-10 02:19:00)
by brad62
Is there a simple way to make a list from a table to find out how many registered people there are in different countries? I was thinking about using DISTINCT for this, but not sure if I'm on the right track. If I have a table called 'members' In this table I have a filed called 'country' What I would like is just a simple list of how many members there is in the countries included....
Started 6 days, 2 hours ago (2009-12-11 19:16:00)
by hannui
Traditionally, it was thought that metaphysics would strive to achieve to reach “behind" the facts, findings and biases appearing to humans, and to tell the ultimate truth about things. In order to metaphysics to be at all possible, the ultimate nature of reality should be, at least in principle, understandable, i.e. the reality should be structured so ...
Started 1 week, 1 day ago (2009-12-09 11:05:00)
by Tailslide
Hi all. I'm hoping you can point me in the general direction of what I need to do. I've got 2 tables (abbreviated): orders: order_id, id, sessionid products: id, title, ref What I need is a select query which will pull all the info from both but display only one row per orders.id. I think I need to use DISTINCT but I've read that it doesn't work with JOINs - is there ...
Started 5 days, 7 hours ago (2009-12-12 14:18:00)
by Daniel Posner
http://blindtaste.com/2009/12/12/parker ... t-reviews/ Interesting read. Brad Coelho always makes fun of critics, by saying that that have a tasting review "drop down box" on their computer to compile TNs with. Meaning that when they run out of things to say about the wine, they just see what is available in the "drop down box" and fill in the blanks. As I read these very different TNs from...
