Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 42

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 18th November 2017, 07:43
pralash pralash is offline
Senior Member
Join Date: Feb 2017
Posts: 203
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Find the SQL Distinct count
Baan: Other/Unknown
C/S: None/Unknown


I'm using the following sql query for find out the distinct count for a column... But I got the result as wrong( total number of records) instead of find out the distinct count..

select distinct count(tctls903.user):counter
from tctls903

Could you please assist me how to get the count of distinct column value by modifying the above query...
Thanks in advance...
Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Find distinct Record frenny Tools Development 2 13th September 2014 05:22
Count distinct field ailisee Distribution, Transportation & Warehousing 2 25th July 2011 03:57
Strange error while importing tables: Can not create index 9999 eppesuiG Tools Administration & Installation 8 17th March 2008 04:35
SQL to return distinct table from 2 tables teddybear Tools Development 4 30th August 2006 10:48
Syntax for Distinct in SQL Query Avasarala Tools Development 1 20th May 2003 07:20

All times are GMT +2. The time now is 09:00.

©2001-2017 - -