|
|
Re: regarding sql query [message #618121 is a reply to message #618115] |
Tue, 08 July 2014 05:18 |
|
Michel Cadot
Messages: 68647 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
From your previous topics:
Michel Cadot wrote on Sun, 11 August 2013 09:39...
Please read OraFAQ Forum Guide.
...
pablolee wrote on Tue, 08 October 2013 10:26Hi Irfan. You've posted a few questions now. And in each of those questions, people have given up their time for free to offer you advice. Up until now, you have posted no acknowledgment of their efforts. It is considered a general forum courtesy to post such an acknowledgement (to, for example, say whether the information you received was useful/successful or not)
Cheers
Updated on: Sat, 31 May 2014 15:29 by Moderator*BlackSwan added {code} tags. Please do so yourself in the future.
please read http://www.orafaq.com/forum/t/174502/102589/
Lalit Kumar B wrote on Sun, 01 June 2014 09:35Please provide the create and insert statements.
Michel Cadot wrote on Sun, 15 June 2014 14:00
Maybe you should think to feedback and thank people that helped you in your previous topics before posting a new one.
And maybe you should read and follow OraFAQ Forum Guide and How to use [code] tags and make your code easier to read as already asked to you.
|
|
|
|
Re: regarding sql query [message #618124 is a reply to message #618115] |
Tue, 08 July 2014 05:37 |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
So do it. Firstly you should determine what shall be the result (required columns and values in rows) and what are rules which are leading to it.
Then, I would start with SELECT keyword. As you did not post any SQL for reproducing your environment (CREATE TABLE + INSERT statements, see http://www.orafaq.com/wiki/Test_case), I will not post ant SQL too.
P.S. I am sure that spammers will love you for publishing your email on public forum.
|
|
|
|