on 07-13-2012 8:00 AM
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.................
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.