Group By Top 1. Try this query. If you want to get top 2 records top n records for each group you can write complicated code for it or just used ranking windows function.
Ben tubbs and craig haynes on target for. Top1 by group of very huge 100000000 table. The following sql lists the number of.
If you want to get top 2 records top n records for each group you can write complicated code for it or just used ranking windows function.
In the following script i have used windows function and have listed top 2 students from each class based on their marks. Sanjeev sureshkumar and russell jones fired pegasus 81 to the top of division 4 as they won 2 1 against medway knights. In this code if at currentcountry is the same we increment rank otherwise set it to 1. Windowgroupbycolumns windowpartitionbygroupbycolumns ordereddf dfselectdfcolumns frownumberoverwindowgroupbycolumnsorderbyorderbycolumndescaliasrowrank.