我想在oracle中查看以上数据 [英] i want to see the above data in oracle

问题描述

hi
我只想从上表中看到WW和PD的UP字段.

hi
i want to see only the WW and UP of PD field from the above table.

PDL_ID_PDI PD PDL_TS_CR PDL_TS_CREA
---------- -- --------- -----------
    202754 WW 21-FEB-12 21-FEB-2012
    202755 WW 21-FEB-12 21-FEB-2012
    202748 WW 21-FEB-12 21-FEB-2012
    202749 WW 21-FEB-12 21-FEB-2012
    202750 WW 21-FEB-12 21-FEB-2012
    202751 WW 21-FEB-12 21-FEB-2012
    202742 WW 21-FEB-12 21-FEB-2012
    202743 WW 21-FEB-12 21-FEB-2012
    202744 WW 21-FEB-12 21-FEB-2012
    202745 WW 21-FEB-12 21-FEB-2012
    202746 WW 21-FEB-12 21-FEB-2012
    202747 WW 21-FEB-12 21-FEB-2012
    202722 PR 21-FEB-12 21-FEB-2012
    202723 PR 21-FEB-12 21-FEB-2012
    202724 PR 21-FEB-12 21-FEB-2012
    202725 PR 21-FEB-12 21-FEB-2012
    202726 UP 21-FEB-12 21-FEB-2012
    202727 UP 21-FEB-12 21-FEB-2012
    202728 UP 21-FEB-12 21-FEB-2012
    202729 UP 21-FEB-12 21-FEB-2012
    202730 UP 21-FEB-12 21-FEB-2012

推荐答案

嗨阿努帕姆
如果只有您感兴趣的数据，则此表中的PD为"WW"或"UP"的条目为何不只是:

Hi Anupam
If the only data you are interested in, in this table is entries where PD is "WW" or "UP" why not just:

select * from TABLE_NAME where PD = 'WW' or PD = 'UP'

或者，如果您希望返回PD列:

alternatively if you want the PD column returned:

select PD from TABLE_NAME where PD = 'WW' or PD = 'UP'

我不太确定第二个查询的用处.

I''m not too sure how useful the second query is.

您的问题不明确.

1.是否要获取PD字段值为"WW"或"UP"的行?然后使用:

Your question is vague.

1. Do you want to get the rows where the value of the PD field is either ''WW'' or ''UP''? Then use this:

select * from TABLE_NAME where PD = 'WW' or PD = 'UP'

2.还是只选择PD字段的值是"WW"或"UP"的值?然后使用:

2. Or do you want to select the values of only PD field where its'' value is either ''WW'' or ''UP''? Then use this:

select PD from TABLE_NAME where PD = 'WW' or PD = 'UP'

3.还是要在2中获得结果，但显示不同的字段?

3. Or do you want to get the result in 2, but show the distinct fields?

select distinct PD from TABLE_NAME where PD = 'WW' or PD = 'UP'

但是我必须对您说:不要亲自得到这个.但是，请先参考好的SQL教程.您似乎甚至不具备基本的SQL知识(如果我的假设是正确的话).这是一个不错的选择: http://www.w3schools.com/sql/default.asp [ ^ ]

But I have to say this to you: Don''t get this personally. But refer to a good SQL tutorial first. You seem not to even have the basic SQL knowledge (if my assumptions are true). Here''s a good one: http://www.w3schools.com/sql/default.asp[^]

这篇关于我想在oracle中查看以上数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！