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,

---

Explain commit, rollback and savepoint.

0 Answers  

---

What is parameter substitution in sql?

0 Answers  

---

What are actual parameters and formal parameters?

0 Answers  

---

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

---

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---

What is sql in oracle?

0 Answers  

---

What is difference between procedure and trigger?

0 Answers  

---

Explain what is rdbms?

0 Answers  

---

Why schema is used in sql?

0 Answers  

---

What are data types in pl sql?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---