Select count(Distinct XX)

(0) Share

Report

Posted on by Piyush Adhikari

2,546

Hello everyone!!

i want to count unique PackingSlipId from vendpackingSlipTrans.

[

SQL STATEMENT:

select count(Distinct itemId) from INVENTTRANS

]

How can i achieve this w/o using While Loop or SysQuery::countTotal??

Regards,

Piyush Adhikari

*This post is locked for comments

I have the same question (0)

All responses (23)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

select count(Field) from Table

group by Field;

Was this reply helpful? Yes No
Piyush Adhikari 2,546 on at

Like (0)

Report

not working

Was this reply helpful? Yes No
Piyush Adhikari 2,546 on at

Like (0)

Report

already tried it!!

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Try recid

select count(RecId) from Table

group by Field;

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report

What exactly are you trying to count, because you are mentioning two tables (vendPackingSlipJour and InventTrans)?

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report

Applying count when a group clause is present will return the number of records for each distinct group by field, not the number of distinct values.

Was this reply helpful? Yes No
Piyush Adhikari 2,546 on at

Like (0)

Report

sir,

i want to get total unique rows count of any field

for example

SQL - select count(Distinct itemId) from INVENTTRANS

Was this reply helpful? Yes No
Piyush Adhikari 2,546 on at

Like (0)

Report

always return 1

Was this reply helpful? Yes No
Piyush Adhikari 2,546 on at

Like (0)

Report

or

SQL - select count(packingSlipId) from VendpackingSlipTrans

Was this reply helpful? Yes No
Piyush Adhikari 2,546 on at

Like (0)

Report

oops

SQL - select count(Distinct packingSlipId) from VendpackingSlipTrans

it looks Distinct is not supported in Ax :(

i dont want to use QueryClass Or while loop

Was this reply helpful? Yes No