Discussions Q&R

Select distinct column 1, column 2 from table name ; and select column 1, column 2 from tablename;

-1 Vote

4th Feb 2017, 3:51 PM

shiva rai

Given an array containing n distinct integers in the range [0,n](inclusive of both 0 and n). Find and return number not in range

0 Vote

19th Feb 2024, 3:19 PM

Anuj Khare

Is there a way to do a DISTINCT on more than one col, say, customer_id and market, and then COUNT customer_id in the same statem

count distinct sql

0 Vote

27th Aug 2017, 3:28 PM

Saurabh

I tried to make a program that accepts a list of elements and prints the sum of distinct elements from the list.What has gone wr

0 Vote

3rd Jan 2020, 5:18 PM

SOUMYADEEP BISWAS

Functions and Methods are similar in many ways in Python, though Methods have two distinct difference, can you explain them!?

functionsvsmethods python

0 Vote

28th Apr 2020, 10:16 PM

Thato Seeletso Mmusi

Why we need to add all ORDER BY column names in SELECT clause when we are using DISTINCT in SELECT?

0 Vote

14th Jun 2017, 5:19 AM

Gladiator

when we use distinct keyword will it be applicable to only the preceding column or will it be applicable to all columns listed in select query?

2 Votes

22nd Jan 2017, 7:10 PM

samhitha

PLEASE HELP! SQL insert into, deleting duplicate rows that have some matching info and same ID

distinct duplicates insert mssql sql

2 Votes

18th Jul 2019, 11:13 PM

Michael Hiatt

I have a PHP multiD array like array($arrayA, $arrayB, $arrayA, $arrayC, $arrayC, $arrayA...........) ho can I get a resulting array which have distinct elements from this array and sorted with the more occurance first like... array( $arrayA, $arrayB, $arrayC) because array $arrayA was 3 tumes in first array so it comes first in resulting array.

0 Vote

1st Nov 2016, 5:56 AM

santosh ojha

< Précédent 1 2 Suivant >

Aujourd'hui en vedette

Ошибка в приложении Sololearn

1 Votes

Is anyone else experiencing this Sololearn issue?

0 Votes

1 Votes

Sololearn course

1 Votes

0 Votes

solo learn program issue - iPhone?

1 Votes

How do I keep myself motivated in coding

0 Votes

Is it possible to write Rust code that is as compact and expressive as Python?

0 Votes

Learn - multiple choice course questions display in one box making it impossible to continue

1 Votes

0 Votes