What is difference between select * from tbl_name dand select count(*) from tbl_name ?
There is difference b/w select * and count (*) in the result value. The select * from tbl_name is show the all value or content in the table and select count(*) is show the no of values or content in the give tables.
There is difference b/w select * and count (*) in the result value. The select * from tbl_name is show the all value or content in the table and select count(*) is show the no of values or content in the give tables.