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..
Answer Posted / vikas kant
select key,count(key1) from [table_name]
group by key
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the dbcc command and why is it used?
What is delete query?
Explain what is lock escalation and what is its purpose?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is msdb database? : SQL Server Architecture
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What the different components in replication and what is their use?
What is data source in connection string?
What are the advantages of stored procedure in sql server?
Tell me something about security and sql azure?
Which table keeps information about stored procedures?
Explain the commands in sql server?
Can we perform backup restore operation on tempdb?
How to add more data to the testing table in ms sql server?
how would you store your query in an SSRS report or a Database server?