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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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: 2457
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 432 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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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: 1903
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: Tue Feb 11 10:17:00 CST 2025