Distinct Results in PS Query

Asked by: Interviewer 9542 views Query

How can you generate DISTINCT results in a PS Query?

sushilpqr on Aug 19, 2013 Reply

Use these steps to access the Query Properties page:

Select Reporting Tools, Query, Query Manager.

Create a new query or search for an existing one.

Click the Properties link on any page of the Query Manager component except the Run page.

The Query Properties page appears.

Distinct : Select this option to eliminate duplicate rows in a query result.

+9 Votes 0 Votes 0 Votes
seema upe on Aug 22, 2013 Reply

Click on properties link in PS Query and then check the distinct Checkbox.

+6 Votes 0 Votes 0 Votes
adhra on Jul 23, 2021 Reply

add new expression
write DISTINCT
then there’s option to include field in that expression from the records addded in ps query,
select field and save
then from expression list click on, use as fields option and make sure that this expression is the first field in ps query

so it’ll be like

Select DISTINCT , 2ns field,3rd field etc

+1 Votes 0 Votes 0 Votes
- adhra on Jul 23, 2021 Reply
  
  the angle bracket was gone when my comment was posted
  
  so it’ll be like
  
  Select DISTINCT [field you selected in expression], 2nd field,3rd field etc
  
  0 Votes 0 Votes 0 Votes