Write a sql select query that only returns each name only once from a table?

0 Answers  

---

What is a rank in sql?

0 Answers  

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

how to retrieve only duplicate values in a table

9 Answers  

---

how to return query output in html format? : Sql dba

0 Answers  

---

---

Explain exception handling in pl/sql?

0 Answers  

---

Why self join is used in sql?

0 Answers  

---

Show code of a cursor for loop.

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

---

What is oracle and pl sql?

0 Answers  

---

Differentiate between syntax and runtime errors.

0 Answers  

---