Query to get number of rows in a table.
select count(*) from tablename
ex:select count(*) as Count from emp
Output
Count
10
SQL Server Faqs
Movie Songs Lyrics
SOftware Testing -QTP Scripts,Testing Faqs
skip to main |
skip to sidebar
SQLQueriesCollection is blog for all sql queries in SqlServer at one place.SQL,SQL Query,SQL Queries,SQL Query Code,SQL Query Example,SQL Query Syntax,Basic Sql Queries,Query,SQL Examples,SQL Basic Queries,Structured Query Language,sql oracle queries,oracle sql queries,sql queries in oracle,sql-oracle,oracle sql.oracle basics,sql basics,oracle sql examples,sql orqcle examples
No comments:
Post a Comment