Search DaniWeb - distinct

Re: ‘Advanced AI should be treated similar to Weapons of Mass Destruction’ 2 Days Ago by Reverend Jim Based on the proliferation of AI generated content, and the age-old rule of garbage in, garbage out, what will be the result of AI models being trained on ever increasing amounts of content generated by other AI platforms? Will we get into a negative feedback loop where the output will become so polluted with bad input that it will be effectively … Re: ‘Advanced AI should be treated similar to Weapons of Mass Destruction’ 2 Days Ago by jwenting Even worse: the junk being deliberately fed to AIs is already at the stage where the results are useless BUT those results are blindly believed by many people BECAUSE they're generated by AI and therefore supposedly automatically correct! Think Google's disastrous launch of their image generator which would under no condition generate Caucasian … ‘Advanced AI should be treated similar to Weapons of Mass Destruction’ 1 Week Ago by Johannes C. … to Demetrius, the **age of AI will unfold in three distinct phases**, introduced here for the first time. An **AGI Control… Distinct Help? 13 Years Ago by turt2live … from there I can handle it) and where partOf is distinct (or never seen again in that column). After the query… Re: Distinct Help? 13 Years Ago by turt2live Nevermind, found a fix. Guess and check worked :P Solution: [CODE]SELECT DISTINCT partOf, rep FROM tickets[/CODE] DISTINCT on One Column Only 14 Years Ago by Billingsley …but have only one column be distinct. The following will make all three columns distinct. I want only the Job_ID …column to be distinct. Can this be done in… Oracle? [code=sql]SELECT DISTINCT Job_ID, Employee_ID, Last_Name FROM Employees ORDER BY Last_Name[/code… Re: DISTINCT on One Column Only 14 Years Ago by Billingsley … It returns the same thing as if I removed the DISTINCT and the subquery. And when I use your code and… only take out the DISTINCT, I get something that looks like a UNION ALL. … [QUOTE=cgyrob;992564]Try something like this. [code=sql] SELECT DISTINCT emp.Job_ID, a.Employee_ID, a.Last_Name FROM Employees emp Join… Re: DISTINCT on One Column Only 14 Years Ago by Billingsley … for all the columns in the SELECT statement, with no distinct? Actually, I did that. I can see that it only… to answer your question it is possible to get the distinct value of one field while displaying multiple fields.[/QUOTE] Re: DISTINCT on One Column Only 14 Years Ago by Billingsley … same thing using the group functions with 2 colulmns as DISTINCT? Thanks again, Lewis [QUOTE=Billingsley;994522]Thank you. This is… for all the columns in the SELECT statement, with no distinct? Actually, I did that. I can see that it only… Distinct 5 random numbers 13 Years Ago by har58 Hi, I need to select 5 distinct random numbers out of 20 in my java program. I am able to select 5 random numbers, But I want these 5 numbers to be distinct,,,i.e. unique for e.g. I dont want them to be like these 5,6,9,6,1 because 6 is repeated I want unrepeated,distinct 5 numbers please ,,help Re: Distinct 5 random numbers 13 Years Ago by har58 …nmbers in an array. (2) when executing program store the distinct 5 random numbers in another array one by one. Should… 255; int selected[] = new int[5]; // store the 5 distinct numbers you were looking for static int search(int a… more random no. and again recheck,,,till all are distinct I think the code will be complicated,, Re: Distinct 5 random numbers 13 Years Ago by tong1 … int selected[] = new int[5]; // store the 5 distinct numbers you were looking for static int search(int a…;); System.out.println(); System.out.println("The 5 distinct numbers selected from the above 20 numbers:"); for (…47 169 51 251 156 64 37 The 5 distinct numbers selected from the above 20 numbers: 191 197… Distinct query help 13 Years Ago by rajeesh_rsn …1 ------------------------------------------------------------------ I want to select using "DISTINCT" I wrote a query as follows [CODE]select… distinct idNo from table where entrytype='1' order…the data according to date .. But I need distinct values .. Please help [CODE]select * from table… Re: DISTINCT on One Column Only 14 Years Ago by cgyrob Try something like this. [code=sql] SELECT DISTINCT emp.Job_ID, a.Employee_ID, a.Last_Name FROM Employees emp Join (Select job_id,employee_id,Lastname From Employees)a on emp.Job_id = a.Job_id ORDER BY a.Last_Name [/code] Re: DISTINCT on One Column Only 14 Years Ago by Billingsley … past. So, the idea is simply to make the job_id DISTINCT, but not the other columns. I doesn't matter how… Re: DISTINCT on One Column Only 14 Years Ago by cgyrob … does accomplish what you were inquiring about. [code=sql] select distinct a.JOB_ID, (Select EMPLOYEE_ID from EMPLOYEE b where b.JOB_ID… Re: DISTINCT on One Column Only 14 Years Ago by Billingsley … does accomplish what you were inquiring about. [code=sql] select distinct a.JOB_ID, (Select EMPLOYEE_ID from EMPLOYEE b where b.JOB_ID… Re: DISTINCT on One Column Only 14 Years Ago by cgyrob … to answer your question it is possible to get the distinct value of one field while displaying multiple fields. Re: Distinct Vlaues 14 Years Ago by masterofpuppets [QUOTE=woooee;1031205]This is very simple to do. [CODE]print len(set([1,2,4,2,7]))[/CODE][/QUOTE] that's really useful... you could also do it in the old fashion way [CODE]def NumDistinctDict( l ): distinct = [] for num in l: if num not in distinct: distinct += [ num ] return len( distinct )[/CODE] Re: Distinct 5 random numbers 13 Years Ago by tong1 … nmbers in an array. (2) when executing program store the distinct 5 random numbers in another array one by one. Should… to 255; int selected[] = new int[5]; // store the 5 distinct numbers you were looking for static int search(int a… distinct Multi Union help 15 Years Ago by EddySR I've got a multi union sql statement however union distinct doesn't work the way I want it to because …I just use distinct on 1 column only (link_id). I've several ideas from… Distinct number.. help 14 Years Ago by wil0022 … the program I have made... This program should show the distinct numbers after you inputted numbers... I really don't know… System.Collections.Generic; using System.Linq; using System.Text; namespace Distinct { class Program { static void Main(string[] args) { int ten = 10… Re: Distinct number.. help 14 Years Ago by Antenka …using nested loops: [code=c#] // the number of distinct values found int numberOfDistinctNumbers = 0; // external loop will… that number // in Final array - then it's distinct and we're adding it if (!alreayExist) { final[… distinct values from multi tables 14 Years Ago by farooq124in …, iam having a requirement where i need to have a distinct value from the result lets say example, contacts table id… to be deleted but it has to show up the distinct values with combination of all the columns. can you please… DISTINCT is returning a duplicate row 13 Years Ago by Zubz15 …code snippet: $query = $this->db->query('SELECT DISTINCT SectionTitle FROM SECTION WHERE SurveyID= '.$number ); $j=1; …>"; $query2= $this->db->query('SELECT DISTINCT Instructions FROM SECTION WHERE SectionID='. $j.' AND SurveyID= '.$number… distinct command 13 Years Ago by saj_amo Hi someone help in distinct command i have created 2 tables department and balance, 1. … 29/Mar/2011 20000 Now i want to use the distinct command that gets all departments latests entered amount, On latest… Re: Distinct query help 13 Years Ago by smantscheff … sorted - 12, 13, or 14/02/2011? You cannot have distinct rows as a GROUP BY result and at the same… Re: Distinct query help 13 Years Ago by crishjeny try this ordering SELECT DISTINCT idNo FROM table WHERE entrytype='1' ORDER BY started asc, started LIMIT 0,10 Distinct on ONE coloumn 12 Years Ago by turt2live …" to the players table. This new column should be distinct, I just have no idea where to throw my… Re: DISTINCT and drop down 10 Years Ago by JorgeM … performing a select on all fields in the table. A distinct in this case will return rows that are unique, not… using one field from the table so while your SQL distinct is working you still see duplicates in that one field…. So instead, your query should be something like this... SELECT DISTINCT field1 FROM [Devices]