如表:pub_state
name price pubyear
科技 35 1997
访谈 25 2003
古典 65 2006
爱情 40 2007在oracle中想通过sql得到pubyear为奇数的记录,请问怎样可写请高手指教
name price pubyear
科技 35 1997
访谈 25 2003
古典 65 2006
爱情 40 2007在oracle中想通过sql得到pubyear为奇数的记录,请问怎样可写请高手指教
from pub_state
where mod(pubyear,2) = 1;