2
Answers

how to arrange rows order in sql ?????

sarfaraz ali

sarfaraz ali

9y
420
1
hi
 
I have a table in database as.
 
 Name value 
First Name
Address
Contact Mobile
State
HospitalName
Post Code
City
Middle Name
Gender
Contact LandLine
Last Name
Country
Specialization

Shyam
H-99
9711964657
UP
Apollo
110092
Noida
Kishor
Male
289874
Pachauri
India
Dental
 
 
I want to arrange table row order like this  how i can do this please suggest 
 
 Namevalue 
 Specialization
HospitalName 
First Name 
Middle Name 
Last Name 
Gender 
Contact Mobile 
Contact LandLine
Address 
City 
State 
Country 
Post Code 
 
Dental
Apollo
Shyam 
Kishor
Pachauri 
Male 
9711964657 
289874
H-99
Noida
Up 
India 
 201301
 
 
 
Answers (2)