how to show it ?? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to show it ??

Author

Topic

chulz90
Starting Member

26 Posts

Posted - 2012-12-16 : 22:25:59

hello

i've some problem to show the values in my table
DN_NUMBER DN_STATUS
DN001 APPROVED
DN002 DECLINE
DN003 CREATE
DN004 APPROVED
DN005 CANCEL

the question is, how i show DN_NUMBER where DN_STATUS is not APPROVED ???

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-12-16 : 22:32:52

[code]SELECT DN_NUMBER, DN_STATUS
FROM my_table
WHERE DN_STATUS <> 'APPROVED'[/code]

KH
[spoiler]Time is always against us[/spoiler]

chulz90
Starting Member

26 Posts

Posted - 2012-12-16 : 22:35:08

quote:
Originally posted by khtan

SELECT DN_NUMBER, DN_STATUS
FROM my_table
WHERE DN_STATUS <> 'APPROVED'

KH
[spoiler]Time is always against us[/spoiler]

txs any way.....

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources