How Will You Know How Many Peoples Visit Bank Website Daily?
Can anyone give the query for this.
Printable View
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