Counting the records

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

shubhada Valued Member Points: 65 More actions · Answer 1

Try this

select distinct ID from table_name

query returns :

A

1

2

3

RyanRandall SSChampion Points: 13623 More actions · Answer 2

Or this:

select count(distinct A) from table_name

It returns: 3

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.

raj-247939 SSCertifiable Points: 5999 More actions · Answer 3

Sorry not to mention that the ERP application(Naviosion Axapta) we are using do not support distinct function.

so do we have another way of doing this

from

killer

Phil Parkin SSC Guru Points: 246979 More actions · Answer 4

Could you create a distinct view and run your query against that?

If not, please mention what other restrictions you have to work round.

Regards

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

RyanRandall SSChampion Points: 13623 More actions · Answer 5

Erm, how about:

select count(*) from (select A from table_name group by A) a

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.

raj-247939 SSCertifiable Points: 5999 More actions · Answer 6

Hi Ryan,

Thanx It worked like magic.

Thanx to all of u.

from

Killer