Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15575 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dinakar
select col1,count(*) cnt from T1 where col1 in
(select distinct col1 from T1 )
group by col1
| Is This Answer Correct ? | 1 Yes | 6 No |
List the ways to get the count of records in a table?
What is the most restrictive isolation level? : Transact sql
What is lexical units in pl sql?
Explain the advantages and disadvantages of stored procedure?
What is the purpose of using pl/sql?
How do I run a query in pl sql developer?
What do you mean by stored procedures?
How to display the current date in sql?
Where the integrity constrints are stored in Data Dictionary?
How does index help in query performance?
What is the use of partition by in sql?
What does truncate mean in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
