Friday, April 10, 2009

Sql queries

1)how to count the number of entries in the table ?

select count (*) from movies

select count (column name) from tablename

Here if u use this query like

"select count (*) from tablename " then if the table is having a large amount of data . then we will have some problems regarding the execution of this statement in the program as this will create some performance issues.

No comments: