what is the difference between count(*) and count(1) ?
Pradeep
Difference between count(*) and count(1):-1.count(*)will be count the no of records in field and count(1)will be count the only one record field2.The difference is count(1) is faster than count(*).