OraFAQ Forum: SQL & PL/SQL » need to get perfect query

Home » SQL & PL/SQL » SQL & PL/SQL » need to get perfect query (oracle database)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

need to get perfect query [message #632089]

Sat, 24 January 2015 14:04

Ganesha
Messages: 1
Registered: August 2014
Location: India

Junior Member

suppose I have one table as : bank_trans

fields are as follows :

trans_id
user_id
trans_date
amount

I need the query which shows users they perform only one transaction in each month from last 3 months.

Please help me ....

Waiting for your positive reply.

Report message to a moderator

Re: need to get perfect query [message #632091 is a reply to message #632089]

Sat, 24 January 2015 14:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

We speak SQL. Do you?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

How will you or I know when perfect query is posted here?

Report message to a moderator

Re: need to get perfect query [message #632092 is a reply to message #632089]

Sat, 24 January 2015 14:48

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Hints: WHERE, GROUP BY , HAVING.

Report message to a moderator

Previous Topic:	Subtracting Years from As_Of_Date
Next Topic:	error while running procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 27 00:30:03 CDT 2026