Sorting the Data based on same set of columns

Question

I have two columns named country and country1 in the same table which are having same datatype and data stored also same i.e., India and United_states, but country has 40 rows of data which is combination of India and United_states and country1 has 60 rows. I need to sort the data based on India and United_states separately. So can any1 help me in this? when i am trying to sort the data either country1 gets sorted or country gets sorted but not both using MySQL.

#Name#  #country#           #country1#
  A      India               United states
  B      United states       United states
  C      India               United states
  D      India               India
  E                          India

i need something like dis

Name# #country# #country1

A India
C India D India India E India

Are you talking about sorting in SQL? If yes which DBMS (Postgres, Oracle, ...) are you using? And how do your tables look like? — , Jul 08 '15 at 09:56
Have you looked here: http://stackoverflow.com/questions/2051162/sql-multiple-column-ordering — shapiro yaacov, Jul 08 '15 at 10:05

Citizen SP · Answer 1 · 2015-07-09T07:03:39.553

0

Try this:

   SELECT * FROM your_table WHERE country = 'India' AND country1 = India ORDER BY country DESC, country1 DESC

edited Jul 09 '15 at 07:03

answered Jul 08 '15 at 11:02

Citizen SP

1,411
7
36
68

i tried it but wat i want is the data for a particular country not both at the same time – Chaithanya Jul 08 '15 at 11:43
SELECT * FROM your_table WHERE country = 'India' ORDER BY country DESC, country1 DESC – Citizen SP Jul 08 '15 at 12:00
When i am trying dis query i ll get country as India but country1 will have both Unitedstates and India – Chaithanya Jul 09 '15 at 04:37
it is not working and if i create another table will it work? – Chaithanya Jul 09 '15 at 08:16

Sorting the Data based on same set of columns

Name# #country# #country1

1 Answers1