test3.txt

来自「用C++实现的MINI SQL服务器 支持标准的常用SQL查询语句」· 文本 代码 · 共 18 行

select * from t1;

select * from t1 where id>6;
select * from t1 where id<3;
select * from t1 where id>=6;
select * from t1 where id<=3;
select * from t1 where id=6;
select * from t1 where id<>6;

select * from t1 where name='Jim';
select * from t1 where name<>'Jim';
select * from t1 where name>='Queen';
select * from t1 where name<='Jim';

select * from t1 where salary<1850.00;
select * from t1 where salary>=4000.00;
select * from t1 where salary=3000.00;
select * from t1 where salary<>3000.00;