Home » RDBMS Server » Server Administration » Re: Help with an Oracle SQL Statement
Re: Help with an Oracle SQL Statement [message #374891] Tue, 10 July 2001 05:01 Go to next message
Babu Paul
Messages: 38
Registered: November 2000
Member
The above query should have a where condition for strip no. This query can be used successfully to find the decision for a particular strip no only.

ie. select...from
where stripno = &stripno
group...

Thanks,
Babu

Report message to a moderator

Re: Final Select [message #374893 is a reply to message #374891] Tue, 10 July 2001 05:12 Go to previous message
Babu Paul
Messages: 38
Registered: November 2000
Member
Sorry for all the mess up... took some time for me to think and come up with a final query; getting rid of where clause.

Here is the final Select

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

Regards
Babu

Report message to a moderator

Previous Topic: Re: Help with an Oracle SQL Statement
Next Topic: Re: SQL*PLUS default path
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

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