rank

url trailing slash and seo

Hi, Which is better for SEO and page rank? mysite.com/directory/my-page OR mysite.com/directory/my-page/ I know the above two URLs are treated as two separate pages by search engines, but I'm stuck on deciding which format to consistently use and which is better. Thanks, Ham ...

Page Rank api for Bing,Yahoo in Java

Hi, Is there any Bing api, yahoo api to find page rank of a keyword or Domain name on its search. Thanks in Advance ...

calculate rank in highscore from 2 tables

i have a trivia game and i want to reward users for 2 events: 1) answering correctly 2) sending a question to the questions pool i want to query for score and rank of a specific player and i use this query: SELECT (correct*10+sent*30) AS score, @rank:=@rank+1 AS rank FROM ( trivia_players JOIN ( SELECT COUNT(*) AS sent,...

Setting rank to NULL using RANK() OVER in SQL.

In a SQL Server DB, I have a table of values that I am interested in ranking. When I perform a RANK() OVER (ORDER BY VALUE DESC) as RANK, I get the following results (in a hypothetical table): RANK | USER_ID | VALUE ------------------------ 1 | 33 | 30000 2 | 10 | 20000 3 | 45 | 10000 4 | 12 | 500...

How to increase Alexa rank ?

Hello, I'm trying to sell my ad slot via BSA and the advertisers are looking for the "alexa rank" to make their call. The problem is that my alexa rank is not good at all. Alexa Rank : 2,117,406 My stats : 12,000 visits per month / 120,000 viewed pages per month Website launched 2 months ago. Domain is : Seek Team which ends up to ...

how to get mysql ranking among results with same id

Quick question, I have a table of messages each with a timestamp and a reply_id and a topic_id. Reply_ids can be the same as others, which means those messages are in the same group of replies. When I select a reply_id with the min timestamp, meaning it was the first message of that group, I would also like to know its numbered place wit...

Rank in c sharp

after filling an array about 20 elements with students marks then rank 1 to highest marks of all student then increase rank to 2 to next highest marks of all student or remaining students this just class management please help me to write algorithm in c# or C or C++ or java ...

SQL: get the place in results query

I have a table called 'points' that has a field 'total' which contains the total points for a record. Now I would like to calculate the rank of a specific record. So like: SELECT (...) as rank FROM points WHERE id=63 Is this possible in SQL? ...

sql output as a ranking

If I have a table of random values in a sql table, how can I export and display them as a raking rather than the absolute value... for example.. if the three values are 30 85 and 90 how do i get 30 do display as 1 or 1st, 85 as 2 or 2nd etc ...