Page History
...
| SQL | JPA | |
|---|---|---|
| < | WHERE 44 < age | findByAgeGreaterThan(int age); |
| <= | WHERE 44 <= age | findByAgeGreaterThanEqual(int age); |
| > | WHERE age < 44 | findByAgeLessThan(int age); |
| 범위 | WHERE age BEETWEEN 10 and 20 | findByAgeBetween(int low,int high); |
| 부분범위 | WHERE age in ( 34,35,36) | findByAgeIn(int age[]); |
| AND | WHERE 40 < age AND sex='남' | findByAgeGreaterThanAndSex(int age,String sex); |
| OR | WHERE 40 < age OR sex='여' | findByAgeGreaterThanOrSex(int age,String sex); |
...