Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

What are different types of statements supported by sql?

0 Answers  

---

Can we insert in sql function?

0 Answers  

---

what is global variable in package

3 Answers   Polaris,

---

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

---

---

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

---

What is meant by truncate in sql?

0 Answers  

---

How do you rename a table in sql?

0 Answers  

---

What is a field in a database?

0 Answers  

---

What is sorting in sql?

0 Answers  

---

What is the difference between a subquery and a join?

0 Answers  

---

Types of joins ?

3 Answers   Digital GlobalSoft, HeadStrong,

---