hi i need to know how to query a number of count on a particular table
let say i have emp_id and emp_name field. on my table their are 2 records.
the result looks this:
rowcount | emp_id | emp_name
1 1000 albert
2 2000 leah
is it possible?
thanks,
albert