Results 1 to 6 of 6

Thread: SQL Query needed

  1. #1
    Join Date
    Mar 2010
    Posts
    2

    SQL Query needed

    How Will You Know How Many Peoples Visit Bank Website Daily?
    Can anyone give the query for this.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Don't think people can help with what you posted.

  3. #3
    Join Date
    Mar 2010
    Posts
    2
    Hi..rmiao..

    this was the question asked in interview for software testing in RBS.
    i dont know whether u have misunderstood me. They asked me to write the query.. I am not aware of sql. so only i asked. If u know u can reply. if u donno get the clarification. dont try to take the negative sense.

  4. #4
    Join Date
    Apr 2009
    Posts
    86
    aditya_cn, the only answer to that question as it is asked is "You Count Them".

    Beyond that, it is totally dependent on how the information is stored or kept track of.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    aditya_cn, you have to provider details when ask for help. People can't guess what you need, it's commom sense instead of negative. I should let you know as forum moderator.

  6. #6
    Join Date
    Mar 2010
    Posts
    1
    SELECT
    {datefield}
    COUNT(*) AS Visits
    FROM
    {weblogtable}
    GROUP BY
    {datefield}
    ORDER BY
    1 DESC

Posting Permissions

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