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

Is stored procedure faster than query?

969

How to rename a table?

1017

Can we commit in trigger?

974

Can we join 3 tables in sql?

1043

How can you fetch common records from two tables?

1063

Can a foreign key be null?

1090

What is rowid in sql?

984

Explain locks? : Transact sql

1002

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1345

What are the types of operators available in sql?

1060

What is sqlite used for?

999

What does the sign mean in sql?

989

what are the 'mysql' command line options? : Sql dba

1072

What is difference between nchar and nvarchar?

1026

what is online transaction processing (oltp)? : Sql dba

994