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 the difference between char_length and length? : Sql dba

0 Answers  

---

Can you sum a count in sql?

0 Answers  

---

Is pl sql still used?

0 Answers  

---

How do you go back in sql?

0 Answers  

---

how to retrieve the top 3 salaries of the table using rownum

31 Answers   Oracle,

---

What is sql not null constraint?

0 Answers  

---

What is relationship? How many types of relationship are there?

0 Answers  

---

what are ddl statements in mysql? : Sql dba

0 Answers  

---

Explain polymorphism in pl/sql.

0 Answers  

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

Do you understand the meaning of exception handling?

3 Answers  

---