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 are the different schemas objects that can be created using pl/sql?

0 Answers  

---

what is union, minus and interact commands? : Sql dba

0 Answers  

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---

What is blind sql injection?

0 Answers  

---

What is sql query limit?

0 Answers  

---

Is left join inner or outer?

0 Answers  

---

Can we join 3 tables in sql?

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

List the various privileges that a user can grant to another user?

0 Answers  

---

How can triggers be used for the table auditing?

0 Answers  

---

What are analytic functions in sql?

0 Answers  

---