select source, destination, distance from Distance

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 / deepak

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

Answer Posted / deepak

select source, destination, distance from Distance_rcd where source>destination
union select destination, source, distance from Distance_rcd where source<destination

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why is pl sql used?

962

What is sql*plus?

1054

What is ttitle and btitle?

1046

What is the basic form of sql query?

922

What is a column in a table?

1106

What is sharding in sql?

955

What are all the ddl commands?

1169

how to get a list of columns in an existing table? : Sql dba

947

What is a string data type in sql?

1020

What does count (*) do in sql?

980

What is difference between mysql and postgresql?

1116

Is oracle sql free?

968

Is nosql faster than sql?

998

What are the different ways to optimize a sql query?

928

What is date functions?

1013