select distinct greatest(source,destination),least(source,destination) from

source destination distance
chennai bangalore 500
bangalore chennai 500
hyd delhi 1000
delhi hyd 1000
bangalore hyd 800

Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria.
Based on the distance i want to display only one row using sql query?

Question Posted / nihar meher

4 Answers
11810 Views
JPMorgan Chase, I also Faced
E-Mail Answers

Answer Posted / nihar meher

select distinct greatest(source,destination),least(source,destination) from tablename;

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do we need cursor in pl sql?

1090

What is an emotional trigger?

936

Name the operator which is used in the query for pattern matching?

895

What is left join in sql?

1006

What is difference between sql and excel?

1011

What are local and global variables and their differences?

1049

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

993

how to drop an existing table in mysql? : Sql dba

988

define join and explain different type of joins? : Sql dba

900

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1045

Is left join same as join?

939

What are the 3 modes of parameter?

1103

What are the commands used in sql?

1017

Is a view faster than a stored procedure?

905

What is trigger explain it?

966