select distinct source,destination,distance from dist

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

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

Answer Posted / ajitnayak

select distinct source,destination,distance from dist_tab where source > destination
minus
select distinct source,destination,distance from dist_tab where source < destination

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create your own reports in sql developer?

1024

what are the different tables present in mysql? : Sql dba

984

How many tables can you join in sql?

958

How do you run a query?

995

What is spool?

1058

What are the two types of periodical indexes?

940

Why do you partition data?

1026

Is big data nosql?

954

What are the two virtual tables available at the time of database trigger execution?

1223

What normalization means?

982

What is the life of an sql statement?

1024

What are two statement types in sql?

1111

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2281

What is normalisation and its types?

1008

What is a parameter query?

1090