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
- 19676 Views
- 3i Infotech, Rolta, TCS, I also Faced
- E-Mail Answers
Answer Posted / hitesh kumar vyas s
Take a example as to find the same student who got first and
second marks in each of sub.
SELECT RollNo,COUNT(Rank) FROM Student GROUP BY RollNo,rank
ORDER BY rank
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
When would you use it?
How do I find the sql server instance name?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Using the customer, and order table in northwind database, please write a query to produce xml?
what is the maximum size of a row? : Sql server database administration
How to scale out a federation by Sql statement?
What does set rowcount do?
What new data source types were added in ssrs 2014?
What are the different sql server versions?
How you can get the list of largest tables in a database?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is intellisense?
What is an index. What are the types?
How to execute function in stored procedure sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
