- 1

Select distinct name, email from USER;

what should this command return ??.... is this possible to get distinct elements from both name and email tables of only from one .

30th Mar 2017, 7:43 PM
Vibhuti Narayan
Vibhuti Narayan - avatar
1 Answer
0
The table in question is USER, the name and email are fields. Thus if your result set brings more than one name with the same email, it will shown just once.
23rd Aug 2017, 7:05 AM
Rodrigo Estevao
Rodrigo Estevao - avatar