forum

Home / DeveloperSection / Forums / Getting table data with total counts

Getting table data with total counts

Anonymous User231618-May-2013
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. 


Updated on 18-May-2013
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By