OraFAQ Forum: SQL & PL/SQL » select queries

Home » SQL & PL/SQL » SQL & PL/SQL » select queries (oracle 10g)

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

select queries [message #572713]

Sun, 16 December 2012 08:48

rajmighty972
Messages: 11
Registered: December 2012

Junior Member

Hi

Need select queries for the following ones.

1. In a Table if both name & data of birth columns are same and if it is more than 1 per group where group is one more column which is unique.

2. for a group column we need to check for occupation column as "ENGG" Atleast once to be avilable.

3. for a group column the count should not be more than 3.

[Updated on: Sun, 16 December 2012 09:17] by Moderator

Report message to a moderator

Re: select queries [message #572715 is a reply to message #572713]

Sun, 16 December 2012 09:00

BlackSwan
Messages: 20085
Registered: January 2009

Senior Member

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

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: select queries [message #572717 is a reply to message #572713]

Sun, 16 December 2012 09:16

Michel Cadot
Messages: 54125
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

From your previous topic:

Michel Cadot wrote on Thu, 13 December 2012 20:02

Welcome to the forum.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

With any SQL or PL/SQL question, please, Post a working Test case: create table and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
...

And feeback to those that help you.
I'm still waiting for you in your previous topic.

Regards
Michel

Report message to a moderator

Re: select queries [message #572718 is a reply to message #572717]

Sun, 16 December 2012 09:36

BlackSwan
Messages: 20085
Registered: January 2009

Senior Member

rajmighty972 wrote on Thu, 13 December 2012 11:06

Thanks Michel..will follow accordingly

Starting when exactly?

Report message to a moderator

Previous Topic:	Character String Buffer too small
Next Topic:	Please help me to write a SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 06:34:32 CDT 2013

Total time taken to generate the page: 0.06372 seconds