Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Sorting with out defining the column in select list when distinct is used
October 30, 2010
Please tell me some other way to sort the result set with a particular column when distinct keyword is used/
Syed Shakeer Hussain
Posted Date: October 30, 2010 Points: 5
Run this query
SELECT sample_columnFROM [Table] GROUP BY sample_column
ORDER BY COUNT(sample_column) DESC
To post reply
Related Questions Related Questions
Sorting Based on click on the Header column in a GridView
How to get column in list to show color bar chart?
multi select checkbox list in dropdown
Displaying multi lines of text column in a list/data view in sharepoint 2010
populate data from visual webpart fileupload control into custom list column.
List info of all Mobile devices & Select COM Port for a device
How to Add a List View control in the Web Application
How can we select a particular row in the listview control
User can not select TEXT for copy paste from my .aspx page...
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend