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 / guest
3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of optimization?
How raid can influence database performance?
What is table-valued sub query?
what is the different types of backups available in sql server? : Sql server database administration
What have included columns when we talk about sql server indexing?
What is the sql server 2000 version number?
What is nonclustered index with included columns ?
Explain the categories of stored procedure?
What does Master database contains?
Explain optimistic and pessimistic concurrency?
What is Extended user-defined?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
When a primary key constraint is included in a table, what other constraints does this imply?
What are transactions and its controls?
What is the default port for SQL Server over a firewall?