GeekInterview.com
Series: Subject: Topic:
Question: 153 of 276

What is the difference between Sort and Filter function

e.g i have a column having data as 1, 5, 7, 3, 4, 5, 9

Sorting will sort as 1,3,4,5,5,7,9
What will ranking do???
Asked by: nikitababaria | Member Since Feb-2007 | Asked on: Feb 14th, 2007

View all questions by nikitababaria

Showing Answers 1 - 3 of 3 Answers
praveen

Answered On : Feb 15th, 2007

Hi all,In Report if we use sort it will disply only either asending ordar ordecending order.where as in Filter, it is an condition that limits the amount of data that can displyed in the report.Those records that satisfy the condition only are displyed in the record.Cheers,Praveen

  
Login to rate this answer.

Sort means to sort data or value in Ascending or Descending order. But Filter means to filter any unnecessary data(according to requirement). For example in your case if you sort data by Ascending order it will show up like this..1,3,3,5,...and so on.

But if you filter data to not show greater than 5 your report will not show that data above 5.

  
Login to rate this answer.
anuanu

Answered On : May 24th, 2008

View all answers by anuanu

Hi, it seems u r confused, you have asked the question as diff b/n sort and filter and the given scenario is on sort and ranking.

diff b/n sorting and ranking is : if u apply a sort on a particular object , that object will get sorted according to the order given by you either ascending or descending. where as rank is u cant directly apply a rank on single object , it is u r giving rank to a dimensional  object (eg: ename) based on measure (salary). directly you cant give rank to salary.

Hope it would help U.

:)

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.