将 这些数据 101,679,681,683,685,687,689,691,693,695,697,699,701,703,705,707,709,711,713,715,717,719 转换成 达梦数据库 select 常量多条数据
时间: 2023-10-04 21:06:05 浏览: 61
可以使用如下语句将这些数据转换成达梦数据库 select 常量多条数据的形式:
```
SELECT 101 UNION ALL
SELECT 679 UNION ALL
SELECT 681 UNION ALL
SELECT 683 UNION ALL
SELECT 685 UNION ALL
SELECT 687 UNION ALL
SELECT 689 UNION ALL
SELECT 691 UNION ALL
SELECT 693 UNION ALL
SELECT 695 UNION ALL
SELECT 697 UNION ALL
SELECT 699 UNION ALL
SELECT 701 UNION ALL
SELECT 703 UNION ALL
SELECT 705 UNION ALL
SELECT 707 UNION ALL
SELECT 709 UNION ALL
SELECT 711 UNION ALL
SELECT 713 UNION ALL
SELECT 715 UNION ALL
SELECT 717 UNION ALL
SELECT 719;
```
查询结果为:
```
101
679
681
683
685
687
689
691
693
695
697
699
701
703
705
707
709
711
713
715
717
719
```
阅读全文