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
How to list all user defined functions in the current database?
What do you mean by data manipulation language?
How to copy the tables, schema and views from one sql server to another?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Explain how would you store your query in an SSRS report or a Database server?
What are wait types?
What is a DBMS, query, SQL?
Explain syntax for dropping triggers?
What is extent? Types of extents?
List out some of the requirements to set up a sql server failover cluster?
How to disable a login name in ms sql server?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is Federation and Federation Member?
What is data compression?
how to create a scrollable cursor with the scroll option? : Sql server database administration