Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009

    Unanswered: Count(*),count(1),count(2).......count(3)

    if i execute a query "select count(*) from table_name"
    then it gives me the total no of records in the table..
    i m really surprised when i get same result when i execute a
    query "select count(1) from table_name"
    "select count(2) from table_name"
    "select count(3) from table_name"
    "select count(9) from table_name"
    it s also gives me the total no of records....
    can any1 tell why it s so?

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Because they are just the same, no difference. Study this Ask Tom thread.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts