Home » Other » Training & Certification » conditional data extraction
conditional data extraction [message #266665] Tue, 11 September 2007 06:12 Go to next message
sonalshastry
Messages: 52
Registered: September 2007
Member

Hi All


i want to retrive all the client data who are tradeing today for first time

for example

Client No. 1 registered on 1-Aug-2007
& traded first time on 11-Sept-2007

but client No. 2 registered on 5-Aug-2007
& already traded for several time & also tradeingon 11-Sept-2007

now i just want the data of Client No.1 only


how can i put such condition in where clause


please help

sonal
Re: conditional data extraction [message #266668 is a reply to message #266665] Tue, 11 September 2007 06:23 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

better if you had given your table description.You could limit the records using where clause,group by your client and then use having to see only those client who have made the first transaction.


regards,
Re: conditional data extraction [message #266680 is a reply to message #266665] Tue, 11 September 2007 07:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

Regards
Michel
Re: conditional data extraction [message #266699 is a reply to message #266668] Tue, 11 September 2007 08:01 Go to previous message
sonalshastry
Messages: 52
Registered: September 2007
Member

thank you

your advice solved my problem


regards
sonal
Previous Topic: procedure
Next Topic: completed my OCA 9i
Goto Forum:
  


Current Time: Thu Dec 08 16:24:45 CST 2016

Total time taken to generate the page: 0.06342 seconds