Distinct values

Query to select distinct values without using distinct

Questions by Preeti Kulkarni

Showing Answers 1 - 24 of 24 Answers

Shwe

  • Dec 7th, 2014
 

Use Group by to eliminate duplicates.

  Was this answer useful?  Yes

VinodKumar

  • Dec 11th, 2014
 

We Have 2 ways To Answer This Question
1.Using UNIQUE
2.Using GROUP BY

  Was this answer useful?  Yes

Kalyani

  • Dec 16th, 2014
 

Use UNION to eliminate duplicate values.

  Was this answer useful?  Yes

nicky

  • Feb 6th, 2015
 

it works!!but how?
could you please explain the query..

  Was this answer useful?  Yes

DB_ANALYST

  • Feb 17th, 2015
 

You can do a simple group by and it get you distinct.

Code
  1. SELECT LASTNAME, FIRSTNAME

  2. FROM EMP

  3. GROUP BY LASTNAME, FIRSTNAME

  Was this answer useful?  Yes

Akshay Kadam

  • Mar 27th, 2015
 

SELECT DISTINCT LASTNAME FIRSTNAME
FROM EMP;

  Was this answer useful?  Yes

Ashok

  • Mar 21st, 2016
 

There are four ways for this.
1. Using distinct keyword
2. Using group by on all columns
3. Using Union operator
4. Using Analytical functions

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions