Q:

Find highest points of two students in a section

my table 

Here I would like to display
Name of 2 students who got Highest point in each section (Sum of C1points to C3Points).  Also display their each competitions and points.  Duplicate marks also need to be displayed. 
Kindly give query for just one section. 
So final output looks

A:

This will give you results for a single section:
SELECT
  Name,
  SUM(C1Points) AS TotalC1,
  SUM(C2Points) AS TotalC2,
  SUM(C3Points) AS TotalC3,
  SUM(C1Points + C2Points + C3Points) AS TotalAll
FROM myTable
WHERE Section = 'Section1'
GROUP BY Name
ORDER BY TotalAll DESC
LIMIT 2

To read all sections at once with MySQL is complicated.  It's better to read everything and order it correctly, then use PHP to get the first two rows for each section:
SELECT
  Name,
  Section,
  SUM(C1Points) AS TotalC1,
  SUM(C2Points) AS TotalC2,
  SUM(C3Points) AS TotalC3,
  SUM(C1Points + C2Points + C3Points) AS TotalAll
FROM myTable
GROUP BY Name, Section
ORDER BY Section, TotalAll DESC

You'll get a result set like this:
Section 1 first place name and scores
Section 1 second place name and scores
Section 1 third place name and scores
. . . 
Section 1 last place name and scores
Section 2 first place name and scores
Section 2 second place name and scores
and so on...

With the list ordered like this, grabbing the top two rows for each section would be child's play in PHP.