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 difference between insensitive and scroll cursor?
What is the usage of sign function?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What is report snapshot?
What is SubQuery in SQL Server 2008
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
What is the difference between having clause and where clause in sql server?
Tell me what is difference between view and materialized view?
What is the security model used in sql server 2005?
What are the new features of sql server 2008 r2 reporting service?
What is the syntax to execute the sys.dm_db_missing_index_details?
What is the sql server agent?
What method is used by the Command classes to execute SQL statements that return single values?
What are different types of statements that are supported by sql?
How can you list all the columns in a database?