Welcome Guest. Sign in or Signup

4 Answers

Distinct Results in PS Query

Asked by: 6101 views Query

How can you generate DISTINCT results in a PS Query?

Related Questions

4 Answers



  1. 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.

    +7 Votes Thumb up 0 Votes Thumb down 0 Votes



  2. seema upe on Aug 22, 2013 Reply

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

    +5 Votes Thumb up 0 Votes Thumb down 0 Votes



  3. 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

    0 Votes Thumb up 0 Votes Thumb down 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 Thumb up 0 Votes Thumb down 0 Votes


Answer Question