My query is regarding retreiving words from table on the bases of its maximum occurances in column irrespective of a row.

means a word that appears maximum number of times in a column, suppose if i have 10 rows in a table and word "Globe" appears maximum no of times say in 5 rows i want Globe word on the top.


Thanks in advance.