Home » SQL & PL/SQL » SQL & PL/SQL » How to display only details of group by query
How to display only details of group by query [message #441373] Sun, 31 January 2010 02:17 Go to next message
aljabali
Messages: 53
Registered: July 2008
Member
hii

I want to display the details of group by query ?????????
Re: How to display only details of group by query [message #441375 is a reply to message #441373] Sun, 31 January 2010 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use reporting (analytic) function.

Regards
Michel
Re: How to display only details of group by query [message #441378 is a reply to message #441373] Sun, 31 January 2010 02:27 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Ok go ahead...

sriram Smile
How to display only details of group by query [message #441380 is a reply to message #441373] Sun, 31 January 2010 02:31 Go to previous messageGo to next message
aljabali
Messages: 53
Registered: July 2008
Member
hii

I want to display the details of group by query ?????????
  • Attachment: 12.JPG
    (Size: 68.99KB, Downloaded 92 times)
Re: How to display only details of group by query [message #441385 is a reply to message #441380] Sun, 31 January 2010 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which details? What is details?
You use SQL*PLus, so post in TEXT not image.
And explain WITH WORDS what you want, a check mark is meaningless for us.

Regards
Michel
Re: How to display only details of group by query [message #441386 is a reply to message #441373] Sun, 31 January 2010 02:57 Go to previous message
flyboy
Messages: 1831
Registered: November 2006
Senior Member
You already display the details of EMP table, so your question seems to be inaccurate.

Let me guess. Problem is, that EXISTS clause does not filter any row. It happens because it always returns the resultset you showed regardless the displayed row from EMP table. So, either all rows are displayed or none (if the subquery in EXISTS clause would return no rows), nothing between. If you do not want this behaviour, correlate it with the main query. Using table aliases might be necessary. Or (properly) use IN clause instead. Examples of both approaches are available e.g. in this post on AskTom (just follow the link).
Previous Topic: utl_file
Next Topic: Diffrence between object export using expdp and dbms_metadata
Goto Forum:
  


Current Time: Wed Sep 28 05:42:39 CDT 2016

Total time taken to generate the page: 0.31353 seconds