top rows
-
-
Hi, I need to generate a report for top 10 share holders. its not that the first top 10 values. Its the top 10 share holders ( values). I am writing the query in sql server. Please help me to get top 10 share holder values. Thank you. Vasini Vasini
SELECT TOP 10 * FROM Shareholders ORDER BY whatEverColumnMakesThemTop
Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website
-
Hi, I need to generate a report for top 10 share holders. its not that the first top 10 values. Its the top 10 share holders ( values). I am writing the query in sql server. Please help me to get top 10 share holder values. Thank you. Vasini Vasini
Hi
Colin Angus Mackay wrote:
SELECT TOP 10 * FROM Shareholders ORDER BY whatEverColumnMakesThemTop
Put Descending in the Order by clause to get max. top 10 shareholders. :)
Harini