| conditional data extraction [message #266665] |
Tue, 11 September 2007 06:12  |
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  |
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,
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
