cancel
Showing results for 
Search instead for 
Did you mean: 

record count in sql

Former Member
0 Kudos

select  t0.docnum,t0.docdate,t0.doctotal

from

oinv t0           where t0.cardcode='C60000'

group by t0.docnum,t0.docdate,t0.doctotal

This  is my sql query

suppose 25 records are retrieving from the database

how can count the no of records in sql

i know select count(*) from emp

it is retrieving no of records all  ready saved tables in db

but need no of records should be count form what i had written the query..

is it possible

i tried

select  count(  above query)

some error is comming.................

Accepted Solutions (1)

Accepted Solutions (1)

former_member189725
Active Contributor
0 Kudos

Try this

select count(*)  from  (select  t0.docnum,t0.docdate,t0.doctotal

from oinv t0 where t0.cardcode='C60000' group by t0.docnum,t0.docdate,t0.doctotal)

Regards

Ratnajit

Answers (0)