BY/ACROSS关键词：

排序 BY/ACROSS关键词 ：

 

BY  (LOWEST,HIGHEST) N  列名称 AS '别名' NOPRINT

ACROSS  (LOWEST,HIGHEST) N  列名称 AS '别名' NOPRIN

 

TABLE FILE CAR PRINT CAR AS 'WCAR' MODEL AS 'WMODEL' SEATS AS 'WSEATS' BY COUNTRY END

 

TABLE FILE CAR SUM DEALER_COST ACROSS COUNTRY END

BY结果：

PAGE 1
COUNTRY	WCAR	WMODEL	WSEATS
ENGLAND	JAGUAR	V12XKE AUTO	2
	JAGUAR	XJ12L AUTO	5
	JENSEN	INTERCEPTOR III	4
	TRIUMPH	TR7	2
FRANCE	PEUGEOT	504 4 DOOR	5
ITALY	ALFA ROMEO	2000 4 DOOR BERLINA	4
	ALFA ROMEO	2000 GT VELOCE	2
	ALFA ROMEO	2000 SPIDER VELOCE	2
	MASERATI	DORA 2 DOOR	2
JAPAN	DATSUN	B210 2 DOOR AUTO	4
	TOYOTA	COROLLA 4 DOOR DIX AUTO	4
W GERMANY	AUDI	100 LS 2 DOOR AUTO	5
	BMW	2002 2 DOOR	5
	BMW	2002 2 DOOR AUTO	4
	BMW	3.0 SI 4 DOOR	5
	BMW	3.0 SI 4 DOOR AUTO	5
	BMW	530I 4 DOOR	5
	BMW	530I 4 DOOR AUTO	5

 

ACROSS结果：

PAGE 1
COUNTRY
ENGLAND	FRANCE	ITALY	JAPAN	W GERMANY
37,853	4,631	41,235	5,512	54,563

 

提示：

1 BY列名称最大可指定32个，ACROSS列名称最大可指定5个。

2 系统默认升顺，如需降顺请用（ BY HIGHEST 列名称）。

3 排序列名称如不需显示请用（BY 列名称 NOPRINT）。