我必须从表中获取记录，我必须只采用特定状态的Pk列 [英] I Have To Fetch The Records From The Table Which I Have To Take Only The Pk Column For A Particular State

问题描述

PROP_ID USER_ID STATE_WHEN  STATE_FROM  STATE_TO     PROP_REF        ACTION
104549  2423    2011-07-22       0          10     PSR11114072     REQUEST PROGRESSED
104823  227     2011-07-28       0          10     PSR11114077     REQUEST PROGRESSED
106306  1232    2011-08-17       1          10     PSR11114394     REQUEST PROGRESSED
106306  1232    2011-08-17       10         10     PSR11114394     DECISION MADE: Authorised
107996  1842    2011-10-07       0          10     PSR11117041     REQUEST PROGRESSED
109359  1696    2011-11-08       0          10     PSR11121604     REQUEST PROGRESSED
106547  2423    2011-08-22       0          10     PSR11121612     REQUEST PROGRESSED
106765  1923    2011-08-31       1          10     PSR11121654     REQUEST PROGRESSED

从上表我只需要那些状态应该是10而Prop_ref不应该与state_from = 10.

From the above table i required only those are state to should be 10 and the Prop_ref should not be with state_from =10.

推荐答案

尝试：

Try:

SELECT * FROM MyTable WHERE State_to=10 AND State_from != 10

这篇关于我必须从表中获取记录，我必须只采用特定状态的Pk列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！