Interested to Buy Any Domain ? << Click Here >> for more details...
if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..
1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..
- 17 Answers
- 19683 Views
- 3i Infotech, Rolta, TCS, I also Faced
- E-Mail Answers
Answer Posted / javamaster
select key,count(key) from tablename
group by key order by key
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define self join?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What do you understand by check constraint in sql server?
What is logshipping and its purpose?
What are the characteristics of modern DBMS?
Please explain what is “asynchronous” communication in sql server service broker?
How to convert a numeric expression from one data type to another?
What is difference between delete & truncate commands?
Explain contrast amongst grouped and non-bunched records?
What is in place upgrade in sql server?
What are locks in sql?
Explain alternate key, candidate key and composite key in sql server?
where the connection string store in the database
What is check constraint in sql server?
Is resultset an interface?
