Answer Posted / anand
select count(*) from table_name will hold good if there isn't any WHERE clause in it as it is a AGGREGATE Function.. (just additional information)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Which Model uses the SET concept
Explain the difference between clustered and non-clustered index?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How to select true false based on column value in sql server?
Introduction of rollup clause using sum and group by clause?
How to provide login information for a new odbc dsn?
What is the name of the Database which IBM mainframe uses?
What does it mean if @@cursor_row returns a negative number?
What do you mean by subquery?
Why people hate cursor?
Is a primary key unique?
What are “lost updates”?
How to compare the top two records using sql?
How important do you consider cursors or while loops for a transactional database?
