odbtools/odbctest/mql/aaa/12search/17orderby.mql

-- ============================================================
-- Order By 排序查询测试
-- ============================================================

-- 1. 升序排列
select s_name, s_int from /test/aaa/test_search order by s_int asc
/**
output()
**/
;

-- 2. 降序排列
select s_name, s_int from /test/aaa/test_search order by s_int desc
/**
output()
**/
;

-- 3. 多字段排序
select s_name, s_int, s_float from /test/aaa/test_search order by s_int asc, s_float desc
/**
output()
**/
;

-- 4. 带 limit 的排序
select s_name, s_int from /test/aaa/test_search order by s_int asc limit 3
/**
output()
count(3)
**/
;

-- 5. float 排序
select s_name, s_float from /test/aaa/test_search order by s_float asc
/**
output()
**/
;

-- 6. 带 where 条件的排序
select s_name, s_int from /test/aaa/test_search where s_int>10 order by s_int desc
/**
output()
**/
;

-- 7. bool 排序
select s_name, s_bool from /test/aaa/test_search order by s_bool asc
/**
output()
**/
;