Can we alter stored procedure?

0 Answers  

---

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 sql character function?

0 Answers  

---

Why procedure is used in sql?

0 Answers  

---

What will happen after commit statement ?

2 Answers  

---

---

Is sql database free?

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

Explain the savepoint statement.

0 Answers  

---

Can you have a foreign key without a primary key?

0 Answers  

---

What is the difference between delete and truncate statement in sql?

0 Answers  

---

What kind of join is join?

0 Answers  

---

What is rank dense_rank and partition in sql?

0 Answers  

---