Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th November 2017, 08:43
pralash pralash is offline
Senior Member
 
Join Date: Feb 2017
Posts: 129
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

Hello,

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
selectdo
rprt_send()
endselect

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


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 06:22
Count distinct field ailisee Distribution, Transportation & Warehousing 2 25th July 2011 04:57
Strange error while importing tables: Can not create index 9999 eppesuiG Tools Administration & Installation 8 17th March 2008 05:35
SQL to return distinct table from 2 tables teddybear Tools Development 4 30th August 2006 11:48
Syntax for Distinct in SQL Query Avasarala Tools Development 1 20th May 2003 08:20


All times are GMT +2. The time now is 23:24.


©2001-2017 - Baanboard.com - Baanforums.com