SQL
SELECT *
FROM table
WHERE a BETWEEN 1 AND 100
R
方法1: 下标选取
> A <- c(10, 20, 30, 40 ,50, 60, 70, 80, 90)
> A
[1] 10 20 30 40 50 60 70 80 90
> A[2]
[1] 20
> A[2:4]
[1] 20 30 40
> A[c(1,3,5)]
[1] 10 30 50
> A[c(1,2,3,2,1)]
[1] 10 20 30 20 10
> c("a","b","c")[rep(c(2,1,3), times=3)]
[1] "b" "a" "c" "b" "a" "c" "b" "a" "c"
> A[c(1, 2, -3, 5)]
Error in A[c(1, 2, -3, 5)] :
only 0's may be mixed with negative subscripts
> A[-2]
[1] 10 30 40 50 60 70 80 90
> A[-c(1,3,5,7)]
[1] 20 40 60 80 90