SQL Syntax & Distinct

This article provides information regarding the SQL syntax and the use of the DISTINCT criteria in PS Query.

Detailed information

Table of Contents

• SQL
  • SQL View
  • Basics of SQL Syntax
• Distinct
  • Example
  • How to Set a query to Distinct Mode

SQL

SQL View

• PeopleSoft® Query will automatically generate SQL based on how you design your query.
• When you go to the "View SQL" tab, you can see the SQL code.
• You cannot modify the SQL from this page.

Back to top

Basics of SQL syntax

PeopleSoft® utilizes a subset of SQL standard functions. Simply, SQL is a set of instructions listing the SELECT on of specific fields, FROM specific tables WHERE certain circumstances exist.

• SELECT: lists fields or column names used in the query
• FROM: lists tables or records used in the query
• WHERE: lists filters to include or exclude data

Back to top

Distinct

When you wish to have a row of data appear only once—even though it may meet the criteria more than once—use the DISTINCT criteria. Distinct removes duplicate rows of output from the results.  

Example

Suppose you want a query that does not show every prospect, but you're interested in the last school attended for each career. 

Without Distinct

With Distinct

How to Set a query to Distinct Mode

To set a query to "distinct" mode, click the Properties link and check the Distinct check box. 

Back to top