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

What is scalar function?

1033

How many columns should be in an index?

951

Can you join views in sql?

939

What are the different types of triggers?

1116

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2484

What is sql and explain its components?

1043

How does join work in sql?

996

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1037

what is the difference between inner and outer join? Explain with example. : Sql dba

1013

Why self join is used in sql?

963

Write a query to display the current date in sql?

1005

How do I trace sql profiler?

954

Does truncate require commit?

955

What are the different types of database management systems?

982

Explain what is a column in a table?

1085