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
11805 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

What is scalar function in sql?

979

Why we use stored procedure instead of query?

953

how many ways to get the current time? : Sql dba

950

How do you get column names only for a table (sql server)?

1102

What is the difference between local and global temporary table?

991

what is column? : Sql dba

962

What is the sql*loader? : aql loader

1006

Why do we use procedures in sql?

1026

What is pl sql package?

993

What is sql performance tuning?

868

What is the starting oracle error number?

999

What is anonymous block in sql?

1076

What are the two different parts of the pl/sql packages?

1026

Why primary key is required?

939

What type of database is cloud sql?

1046