Search DaniWeb - distinct

Re: ‘Advanced AI should be treated similar to Weapons of Mass Destruction’ 2 Months Ago by rproffitt UPDATE: Feb 4, 2025 — Google on Tuesday updated its ethical guidelines around artificial intelligence, removing commitments not to apply the technology to weapons or surveillance. Distinct Help? 14 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? 14 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 15 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 15 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 15 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 15 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 14 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 14 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 14 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 14 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 15 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 15 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 15 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 15 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 15 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 15 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 14 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 16 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 15 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 15 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 15 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 14 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 14 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 14 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 14 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 13 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 11 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] Distinct value of combobox 11 Years Ago by xpzy1912 …;97b9ab32445018ea1f489e9dee2120fa") The combobox should be able to display the distinct value from the access database but is able to show… all the record on the listbox. I tried to select distinct value through wizard but it is not working. So i… distinct result 10 Years Ago by Raadha …-3 sets of answers, between this time period.. i need distinct set of answers.. if(isset($_POST['submit'])) { $to= $_POST['to… REPORT</h2>"; $result = mysqli_query($con,"SELECT DISTINCT * FROM phar JOIN med ON med.iname = phar.iname JOIN…