"Distinct" Clause in Qury Builder

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
ROSinclair
Posts: 2
Joined: Tue 25 May 2010 16:50

"Distinct" Clause in Qury Builder

Post by ROSinclair » Thu 14 Jun 2012 15:53

Within Data Studio for SQL / using the Query Builder / I can find No way or documentation on how to build a query that will return "Distinct" records without addding the DISTINCT clause to my Select statment manually (by typing it in).

Within Query Bulider, how does one designate that they only want disctinct records returned?

Thanks
RS

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: "Distinct" Clause in Qury Builder

Post by .jp » Thu 14 Jun 2012 16:34

Please tick the "Unique records" checkbox on the "Selection" tab of the query builder document.

Post Reply