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
- 19088 Views
- 3i Infotech, Rolta, TCS, I also Faced
- E-Mail Answers
Answer Posted / neeraj
If the column name is key
select key,count(*) from jojo
group by key
simple
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is sql profiler. What are the default templates with it? : sql server database administration
Does sql server 2016 have ssms?
What are the types of database recovery models?
What is raiseerror? What is raiseerror?
What is the use of toad or sqldbx.?
What is a recursive stored procedure in sql server?
Can a table have 2 foreign keys?
What is the difference between truncate and delete commands?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
Define msdb database?
What is the difference between getdate and sysdatetime?
What is the stored procedure?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What happens on checkpoint?
