Home » SQL & PL/SQL » SQL & PL/SQL » select queries (oracle 10g)
select queries [message #572713] Sun, 16 December 2012 08:48 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 22926
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/
Re: select queries [message #572717 is a reply to message #572713] Sun, 16 December 2012 09:16 Go to previous messageGo to next message
Michel Cadot
Messages: 59499
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

Re: select queries [message #572718 is a reply to message #572717] Sun, 16 December 2012 09:36 Go to previous message
BlackSwan
Messages: 22926
Registered: January 2009
Senior Member
rajmighty972 wrote on Thu, 13 December 2012 11:06
Thanks Michel..will follow accordingly

Starting when exactly?
Previous Topic: Character String Buffer too small
Next Topic: Please help me to write a SQL
Goto Forum:
  


Current Time: Thu Oct 30 23:20:04 CDT 2014

Total time taken to generate the page: 0.08734 seconds