| A | |
| 1 |
 =demo.query("select NAME,ABBR,POPULATION from STATES where left(NAME,1)='T'")
|
| 2 |
=demo.query("select NAME,ABBR,POPULATION from STATES where left(NAME,1)=?","T")
|
| 3 |
=demo.query("select NAME,ABBR,POPULATION from STATES where POPULATION = (select max(POPULATION) from STATES)")
|
| 4 |
=demo.query("select NAME,ABBR,POPULATION from STATES")
|
| 5 |
=A4.select(left(NAME,1)=="T")
|
| 6 |
=A4.maxp(POPULATION)
|
A1、A2和A5中查询结果相同，如下:
A3和A6中查询结果相同，如下:
