Home » RDBMS Server » Server Administration » Re: Help with an Oracle SQL Statement
Re: Help with an Oracle SQL Statement [message #374890] Tue, 10 July 2001 04:56
Babu Paul
Messages: 38
Registered: November 2000
Member
Hi,

Enhancing Sudhakar's query, to make life easier

SELECT DISTINCT(DECODE(count(*),1,Decision,'Reject'))
FROM LaserData
GROUP BY StripNo, Decision;

Hope this helps!

Babu

Report message to a moderator

Previous Topic: Using AND & OR within DECODE statements
Next Topic: Re: Help with an Oracle SQL Statement
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 19:25:53 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.