1. VBA(Excel)
假设你手头有一份学生成绩单,列 A 是学生姓名,列 B 是考试成绩,现在想先按成绩从高到低排序,成绩相同的再按姓名升序排列。
```vba
Sub SortStudents()
Dim ws As Worksheet
Set ws = ThisWorkbook.Worksheets("Sheet1") ' 改成你实际的工作表名
ws.Range("A1:B100").Sort Key1:=ws.Range("B1"), Order1:=xlDescending, Key2:=ws.Range("A1"), Order2:=xlAscending, Header:=xlYes
End Sub
```
2. C++
```cpp
include include void swap(int *a, int *b) { int t = *a; *a = *b; *b = t; } int partition(std::vector int pivot = arr[high]; int i = (low - 1); for (int j = low; j <= high - 1; j++) { if (arr[j] < pivot) { i++; swap(&arr[i], &arr[j]); } } swap(&arr[i + 1], &arr[high]); return (i + 1); } void quickSort(std::vector if (low < high) { int pi = partition(arr, low, high); quickSort(arr, low, pi - 1); quickSort(arr, pi + 1, high); } } int main() { std::vector quickSort(arr, 0, arr.size() - 1); for (int i = 0; i < arr.size(); i++) { std::cout << arr[i] << " "; } return 0; } ``` 3. Python 冒泡排序 ```python def bubbleSort(arr): n = len(arr) for i in range(n): for j in range(0, n-i-1): if arr[j] > arr[j+1]: arr[j], arr[j+1] = arr[j+1], arr[j] return arr ``` 选择排序 ```python def selectionSort(arr): n = len(arr) for i in range(n): min_idx = i for j in range(i+1, n): if arr[min_idx] > arr[j]: min_idx = j arr[i], arr[min_idx] = arr[min_idx], arr[i] return arr ``` 插入排序 ```python def insertionSort(arr): for i in range(1, len(arr)): key = arr[i] j = i-1 while j >= 0 and key < arr[j]: arr[j+1] = arr[j] j -= 1 arr[j+1] = key return arr ``` 快速排序 ```python def quickSort(arr): if len(arr) <= 1: return arr pivot = arr[len(arr)//2] left = [x for x in arr if x < pivot] middle = [x for x in arr if x == pivot] right = [x for x in arr if x > pivot] return quickSort(left) + middle + quickSort(right) ``` 这些示例代码展示了如何在不同的编程语言中实现排序算法。你可以根据具体需求选择合适的排序算法和编程语言。