What is meant by SORTING and GROUPING

bhavana · 23-01-07, 09:42 PM

What is meant by SORTING and GROUPING <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

PrashanthU · 30-01-07, 05:07 PM

SORTING : This refers to the process of arranging the things in order ( either in ascending or descending order ).This operation can be performed on any of the colums in a table.
GROUPING: This refers to the process of collecting things together and displaying them...for example in an organisation we may have different departments...and if we wish to view employee details, department wise...then it would be better to have those rows grouped together based on their department...and if we wish we can sort these grouped rows...

ajithcharles · 03-02-07, 07:08 PM

Grouping is usually used to generate reports .. done by group by clause
sorting (done by order by clause)

**sk_kireeti** · 17-02-07, 12:41 AM

I agree with out friends Prashanth and Ajith on Sorting and Grouping.

Along with above points, I would add 1 point to make grouping more simler. Grouping is used to aggreggate the output before it is displayed.

Thanks,
Krishna

naughty21 · 06-06-08, 01:41 PM

thanks for the info

23-01-07, 09:42 PM	#1 (permalink)
bhavana Senior Member Join Date: Jan 2007 Posts: 598 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 7	What is meant by SORTING and GROUPING What is meant by SORTING and GROUPING <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

30-01-07, 05:07 PM	#2 (permalink)
PrashanthU Senior Member Join Date: Jan 2007 Age: 27 Posts: 103 Thanks: 0 Thanked 7 Times in 5 Posts Thanks: 0 Thanked 7 Times in 5 Posts Rep Power: 4	Re: What is meant by SORTING and GROUPING SORTING : This refers to the process of arranging the things in order ( either in ascending or descending order ).This operation can be performed on any of the colums in a table. GROUPING: This refers to the process of collecting things together and displaying them...for example in an organisation we may have different departments...and if we wish to view employee details, department wise...then it would be better to have those rows grouped together based on their department...and if we wish we can sort these grouped rows... __________________ " Success Is Not Measured By What One Has Achieved, But What One Has Achieved, Compared To What One Is Capable Of " Keep Smiling :-)

03-02-07, 07:08 PM	#3 (permalink)
ajithcharles Senior Member Join Date: Mar 2006 Age: 24 Posts: 343 Thanks: 3 Thanked 12 Times in 12 Posts Thanks: 3 Thanked 12 Times in 12 Posts Rep Power: 8	Re: What is meant by SORTING and GROUPING Grouping is usually used to generate reports .. done by group by clause sorting (done by order by clause) __________________ JSP,Oracle,SQL : http://mycodesnippetjsp.blogspot.com/ Complete List :http://www.blogger.com/profile/04567238067268200918

17-02-07, 12:41 AM	#4 (permalink)
sk_kireeti Super Moderator Join Date: Feb 2006 Location: Hyderabad Posts: 2,355 Thanks: 117 Thanked 241 Times in 198 Posts Thanks: 117 Thanked 241 Times in 198 Posts Blog Entries: 4 Rep Power: 51	Re: What is meant by SORTING and GROUPING I agree with out friends Prashanth and Ajith on Sorting and Grouping. Along with above points, I would add 1 point to make grouping more simler. Grouping is used to aggreggate the output before it is displayed. Thanks, Krishna __________________ Give 1 cup rice to a hungry Indian just by a mouse click. No money, no form filling, no hassle... Click here for the donation.

06-06-08, 01:41 PM	#5 (permalink)
naughty21 Junior Member Join Date: Jun 2008 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: What is meant by SORTING and GROUPING thanks for the info

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: