Select distinct name, email from USER;

Question

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

Answer 1

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.