Hi Mindstickians!
I am having following table (student)
sid sname branch semester
1 Vijay CSE 6
2 Ajay MECH 4
3 Riteh CSE 6
4 Nutan CSE 6
5 Riya ETC 4
6 Ritu CSE 6
Here I want to fetch all record and total fetched record count for that i'm using following query, but this is not able to fetch all records
select *,count(sid) from students
How can we do this?
Please help!
Thanks in advance.
AVADHESH PATEL
18-May-2013