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?

4 Answers   JPMorgan Chase,

---

what is 'trigger' in sql? : Sql dba

0 Answers  

---

Explain the the update statement in sql?

0 Answers  

---

What is Difference Between delete and Truncate?

9 Answers  

---

when is the use of update_statistics command? : Sql dba

0 Answers  

---

---

how would you get the current date in mysql? : Sql dba

0 Answers  

---

What is the use of prepared statement?

0 Answers  

---

What are the set operators in sql?

0 Answers  

---

Can function return multiple values in sql?

0 Answers  

---

How to sort the rows in sql.

0 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

how to get help information from the server? : Sql dba

0 Answers  

---