-
SQL Query needed
How Will You Know How Many Peoples Visit Bank Website Daily?
Can anyone give the query for this.
-
Don't think people can help with what you posted.
-
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.
-
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.
-
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.
-
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
-
Forum Rules
|
|