please provide india districts List in ms SQl

Question

Dharmraj Thakur · Answer

Run this query... CREATE TABLE dbo.Districts ( ID int primary key identity(1,1), DistrictName varchar (50), DistrictCode varchar (50), StateName varchar (50) ); insert into Districts(DistrictName, DistrictCode, StateName) values ( 'Thane' , ' ' , 'Maharashtra' ), ( 'North 24 Parganas' , 'PN' , 'West Bengal' ), ( 'Bangalore Urban' , 'BN' , 'Karnataka' ), ( 'Pune' , 'PU' , 'Maharashtra' ), ( 'Mumbai suburban' , 'MU' , 'Maharashtra' ), ( 'South 24 Parganas' , 'PS' , 'West Bengal' ), ( 'Bardhaman' , 'BR' , 'West Bengal' ), ( 'Ahmedabad' , 'AH' , 'Gujarat' ), ( 'Murshidabad' , 'MSD' , 'West Bengal' ), ( 'Jaipur' , 'JP' , 'Rajasthan' ), ( 'Nashik' , 'NS' , 'Maharashtra' ), ( 'Allahabad' , 'AH' , 'Uttar Pradesh' ), ( 'Patna' , 'PA' , 'Bihar' ), ( 'Hooghly' , 'HG' , 'West Bengal' ), ( 'Ranga Reddy' , 'RA' , 'Telangana' ), ( 'Nadia' , 'NA' , 'West Bengal' ), ( 'East Godavari' , 'EG' , 'Andhra Pradesh' ), ( 'Paschim Medinipur' , 'PM' , 'West Bengal' ), ( 'East Champaran' , 'EC' , 'Bihar' ), ( 'Surat' , 'ST' , 'Gujarat' ), ( 'Guntur' , 'GU' , 'Andhra Pradesh' ), ( 'Howrah' , 'HR' , 'West Bengal' ), ( 'Muzaffarpur' , 'MZ' , 'Bihar' ), ( 'Belgaum' , 'BG' , 'Karnataka' ), ( 'Moradabad' , 'MO' , 'Uttar Pradesh' ), ( 'Chennai' , 'CH' , 'Tamil Nadu' ), ( 'Ghaziabad' , 'GZ' , 'Uttar Pradesh' ), ( 'Nagpur' , 'NG' , 'Maharashtra' ), ( 'Azamgarh' , 'AZ' , 'Uttar Pradesh' ), ( 'Lucknow' , 'LU' , 'Uttar Pradesh' ), ( 'Kanpur Nagar' , 'KN' , 'Uttar Pradesh' ), ( 'Ahmednagar' , 'AH' , 'Maharashtra' ), ( 'Krishna' , 'KR' , 'Andhra Pradesh' ), ( 'Kolkata' , 'KO' , 'West Bengal' ), ( 'Jaunpur district' , 'JU' , 'Uttar Pradesh' ), ( 'Madhubani' , 'MB' , 'Bihar' ), ( 'Sitapur' , 'SI' , 'Uttar Pradesh' ), ( 'Bareilly' , 'BR' , 'Uttar Pradesh' ), ( 'Gorakhpur' , 'GR' , 'Uttar Pradesh' ), ( 'Purba Medinipur' , 'PR' , 'West Bengal' ), ( 'Agra' , 'AG' , 'Uttar Pradesh' ), ( 'Gaya' , 'GA' , 'Bihar' ), ( 'Solapur' , 'SO' , 'Maharashtra' ), ( 'Visakhapatnam' , 'VS' , 'Andhra Pradesh' ), ( 'Samastipur' , 'SM' , 'Bihar' ), ( 'Jalgaon' , 'JG' , 'Maharashtra' ), ( 'Chittoor' , 'CH' , 'Andhra Pradesh' ), ( 'Muzaffarnagar' , 'MU' , 'Uttar Pradesh' ), ( 'Malappuram' , 'MA' , 'Kerala' ), ( 'Hardoi' , 'HR' , 'Uttar Pradesh' ), ( 'Anantapur' , 'AN' , 'Andhra Pradesh' ), ( 'Raipur' , 'RP' , 'Chhattisgarh' ), ( 'Kurnool' , 'KU' , 'Andhra Pradesh' ), ( 'Mahbubnagar' , 'MA' , 'Telangana' ), ( 'Lakhimpur Kheri' , 'LK' , 'Uttar Pradesh' ), ( 'Hyderabad' , 'HY' , 'Telangana' ), ( 'Maldah' , 'MA' , 'West Bengal' ), ( 'Madurai' , 'MA' , 'Tamil Nadu' ), ( 'Kanchipuram' , 'KC' , 'Tamil Nadu' ), ( 'Saran' , 'SR' , 'Bihar' ), ( 'West Champaran' , 'WC' , 'Bihar' ), ( 'West Godavari' , 'WG' , 'Andhra Pradesh' ), ( 'Vellore' , 'VE' , 'Tamil Nadu' ), ( 'Darbhanga' , 'DA' , 'Bihar' ), ( 'Kolhapur' , 'KO' , 'Maharashtra' ), ( 'Jalpaiguri' , 'JA' , 'West Bengal' ), ( 'Karimnagar' , 'KA' , 'Telangana' ), ( 'Sultanpur' , 'SU' , 'Uttar Pradesh' ), ( 'Tiruvallur' , 'TL' , 'Tamil Nadu' ), ( 'Budaun' , 'BD' , 'Uttar Pradesh' ), ( 'Aurangabad' , 'AU' , 'Maharashtra' ), ( 'Jodhpur' , 'JO' , 'Rajasthan' ), ( 'Bijnor' , 'BI' , 'Uttar Pradesh' ), ( 'Varanasi' , 'VA' , 'Uttar Pradesh' ), ( 'Aligarh' , 'AL' , 'Uttar Pradesh' ), ( 'Alwar' , 'AL' , 'Rajasthan' ), ( 'North West Delhi' , 'NW' , 'Delhi' ), ( 'Vadodara' , 'VD' , 'Gujarat' ), ( 'Ghazipur' , 'GP' , 'Uttar Pradesh' ), ( 'Bankura' , 'BN' , 'West Bengal' ), ( 'Kushinagar' , 'KU' , 'Uttar Pradesh' ), ( 'Warangal' , 'WA' , 'Telangana' ), ( 'Ganjam' , 'GN' , 'Odisha' ), ( 'Birbhum' , 'BI' , 'West Bengal' ), ( 'Bulandshahr' , 'BU' , 'Uttar Pradesh' ), ( 'Vaishali' , 'VA' , 'Bihar' ), ( 'Ludhiana' , 'LU' , 'Punjab' ), ( 'Nalgonda' , 'NA' , 'Telangana' ), ( 'Salem' , 'SA' , 'Tamil Nadu' ), ( 'Coimbatore' , 'CO' , 'Tamil Nadu' ), ( 'Saharanpur' , 'SA' , 'Uttar Pradesh' ), ( 'Viluppuram' , 'VL' , 'Tamil Nadu' ), ( 'Meerut' , 'ME' , 'Uttar Pradesh' ), ( 'Gonda' , 'GN' , 'Uttar Pradesh' ), ( 'Sitamarhi' , 'ST' , 'Bihar' ), ( 'Raebareli' , 'RB' , 'Uttar Pradesh' ), ( 'Prakasam' , 'PR' , 'Andhra Pradesh' ), ( 'Nanded' , 'ND' , 'Maharashtra' ), ( 'Durg' , 'DU' , 'Chhattisgarh' ), ( 'Siwan' , 'SW' , 'Bihar' ), ( 'Nagaur' , 'NA' , 'Rajasthan' ), ( 'Thiruvananthapuram' , 'TV' , 'Kerala' ), ( 'Ernakulam' , 'ER' , 'Kerala' ), ( 'Purnia' , 'PU' , 'Bihar' ), ( 'Indore' , 'IN' , 'Madhya Pradesh' ), ( 'Barabanki' , 'BB' , 'Uttar Pradesh' ), ( 'Ballia' , 'BL' , 'Uttar Pradesh' ), ( 'Pratapgarh' , 'PR' , 'Uttar Pradesh' ), ( 'Rajkot' , 'RA' , 'Gujarat' ), ( 'Mumbai City' , 'MC' , 'Maharashtra' ), ( 'Banaskantha' , 'BK' , 'Gujarat' ), ( 'Unnao' , 'UN' , 'Uttar Pradesh' ), ( 'Thrissur' , 'TS' , 'Kerala' ), ( 'Deoria' , 'DE' , 'Uttar Pradesh' ), ( 'Kozhikode' , 'KZ' , 'Kerala' ), ( 'Tirunelveli' , 'TI' , 'Tamil Nadu' ), ( 'Katihar' , 'KT' , 'Bihar' ), ( 'Udaipur' , 'UD' , 'Rajasthan' ), ( 'Bhagalpur' , 'BG' , 'Bihar' ), ( 'Medak' , 'ME' , 'Telangana' ), ( 'Satara' , 'ST' , 'Maharashtra' ), ( 'Shahjahanpur' , 'SJ' , 'Uttar Pradesh' ), ( 'Uttar Dinajpur' , 'UD' , 'West Bengal' ), ( 'Mysore' , 'MY' , 'Karnataka' ), ( 'Sri Potti Sriramulu Nellore' , 'NE' , 'Andhra Pradesh' ), ( 'Rohtas' , 'RO' , 'Bihar' ), ( 'Begusarai' , 'BE' , 'Bihar' ), ( 'Purulia' , 'PU' , 'West Bengal' ), ( 'Ranchi' , 'RA' , 'Jharkhand' ), ( 'Patiala' , 'PA' , 'Punjab' ), ( 'Amravati' , 'AM' , 'Maharashtra' ), ( 'Kadapa' , 'CU' , 'Andhra Pradesh' ), ( 'Bhavnagar' , 'BV' , 'Gujarat' ), ( 'Nalanda' , 'NL' , 'Bihar' ), ( 'Kanyakumari' , 'KK' , 'Tamil Nadu' ), ( 'Nagaon' , 'NG' , 'Assam' ), ( 'Cooch Behar' , 'KB' , 'West Bengal' ), ( 'Sangli' , 'SN' , 'Maharashtra' ), ( 'Palakkad' , 'PL' , 'Kerala' ), ( 'Araria' , 'AR' , 'Bihar' ), ( 'Khammam' , 'KH' , 'Telangana' ), ( 'Yavatmal' , 'YA' , 'Maharashtra' ), ( 'Junagadh' , 'JU' , 'Gujarat' ), ( 'Adilabad' , 'AD' , 'Telangana' ), ( 'South Delhi' , 'SD' , 'Delhi' ), ( 'Bhojpur' , 'BJ' , 'Bihar' ), ( 'Tiruchirappalli' , 'TC' , 'Tamil Nadu' ), ( 'Srikakulam' , 'SR' , 'Andhra Pradesh' ), ( 'Dhanbad' , 'DH' , 'Jharkhand' ), ( 'Tumkur' , 'TU' , 'Karnataka' ), ( 'Sikar' , 'SK' , 'Rajasthan' ), ( 'Maharajganj' , 'MG' , 'Uttar Pradesh' ), ( 'Bilaspur' , 'BI' , 'Chhattisgarh' ), ( 'Raigad' , 'RG' , 'Maharashtra' ), ( 'Fatehpur' , 'FT' , 'Uttar Pradesh' ), ( 'Kollam' , 'KL' , 'Kerala' ), ( 'Cuttack' , 'CU' , 'Odisha' ), ( 'Barmer' , 'BM' , 'Rajasthan' ), ( 'Cuddalore' , 'CU' , 'Tamil Nadu' ), ( 'Buldhana' , 'BU' , 'Maharashtra' ), ( 'Beed' , 'BI' , 'Maharashtra' ), ( 'Ajmer' , 'AJ' , 'Rajasthan' ), ( 'Gulbarga' , 'GU' , 'Karnataka' ), ( 'Gopalganj' , 'GO' , 'Bihar' ), ( 'Siddharthnagar' , 'SN' , 'Uttar Pradesh' ), ( 'Nizamabad' , 'NI' , 'Telangana' ), ( 'Bharatpur' , 'BP' , 'Rajasthan' ), ( 'Mathura' , 'MT' , 'Uttar Pradesh' ), ( 'Bellary' , 'BL' , 'Karnataka' ), ( 'West Delhi' , 'WD' , 'Delhi' ), ( 'Kannur' , 'KN' , 'Kerala' ), ( 'Mayurbhanj' , 'MY' , 'Odisha' ), ( 'Aurangabad' , 'AU' , 'Bihar' ), ( 'Firozabad' , 'FI' , 'Uttar Pradesh' ), ( 'Mirzapur' , 'MI' , 'Uttar Pradesh' ), ( 'Amritsar' , 'AM' , 'Punjab' ), ( 'Tirupur' , 'TP' , 'Tamil Nadu' ), ( 'Tiruvannamalai' , 'TV' , 'Tamil Nadu' ), ( 'Faizabad' , 'FZ' , 'Uttar Pradesh' ), ( 'Basti' , 'BS' , 'Uttar Pradesh' ), ( 'Jabalpur' , 'JA' , 'Madhya Pradesh' ), ( 'Latur' , 'LA' , 'Maharashtra' ), ( 'Giridih' , 'GI' , 'Jharkhand' ), ( 'Sabarkantha' , 'SK' , 'Gujarat' ), ( 'Bhilwara' , 'BW' , 'Rajasthan' ), ( 'Thanjavur' , 'TJ' , 'Tamil Nadu' ), ( 'Ambedkar Nagar' , 'AN' , 'Uttar Pradesh' ), ( 'Panchmahal' , 'PM' , 'Gujarat' ), ( 'Bahraich' , 'BH' , 'Uttar Pradesh' ), ( 'Sagar' , 'SG' , 'Madhya Pradesh' ), ( 'Bhopal' , 'BP' , 'Madhya Pradesh' ), ( 'Bikaner' , 'BI' , 'Rajasthan' ), ( 'Rewa' , 'RE' , 'Madhya Pradesh' ), ( 'Vizianagaram' , 'VZ' , 'Andhra Pradesh' ), ( 'Rampur' , 'RA' , 'Uttar Pradesh' ), ( 'Balasore' , 'BW' , 'Odisha' ), ( 'Gurdaspur' , 'GU' , 'Punjab' ), ( 'Kheda' , 'KH' , 'Gujarat' ), ( 'South West Delhi' , 'SW' , 'Delhi' ), ( 'East Singhbhum' , 'ES' , 'Jharkhand' ), ( 'Erode' , 'ER' , 'Tamil Nadu' ), ( 'Khordha' , 'KH' , 'Odisha' ), ( 'North East Delhi' , 'NE' , 'Delhi' ), ( 'Satna' , 'ST' , 'Madhya Pradesh' ), ( 'Supaul' , 'SU' , 'Bihar' ), ( 'Sambhal(Bheem Nagar)' , 'SM' , 'Uttar Pradesh' ), ( 'Nawada' , 'NW' , 'Bihar' ), ( 'Mau' , 'MB' , 'Uttar Pradesh' ), ( 'Chandrapur' , 'CH' , 'Maharashtra' ), ( 'Dhar' , 'DH' , 'Madhya Pradesh' ), ( 'Jalandhar' , 'JA' , 'Punjab' ), ( 'Vijayapura' , 'BJ' , 'Karnataka' ), ( 'Dindigul' , 'DI' , 'Tamil Nadu' ), ( 'Jamnagar' , 'JA' , 'Gujarat' ), ( 'Balrampur' , 'BP' , 'Uttar Pradesh' ), ( 'Jhunjhunu' , 'JJ' , 'Rajasthan' ), ( 'Dahod' , 'DA' , 'Gujarat' ), ( 'Alappuzha' , 'AL' , 'Kerala' ), ( 'Kutch' , 'KA' , 'Gujarat' ), ( 'Chhindwara' , 'CN' , 'Madhya Pradesh' ), ( 'Anand' , 'AN' , 'Gujarat' ), ( 'Dakshina Kannada' , 'DK' , 'Karnataka' ), ( 'Sundargarh' , 'SU' , 'Odisha' ), ( 'Bokaro' , 'BO' , 'Jharkhand' ), ( 'Dhule' , 'DH' , 'Maharashtra' ), ( 'Churu' , 'CR' , 'Rajasthan' ), ( 'Pali' , 'PA' , 'Rajasthan' ), ( 'Pilibhit' , 'PI' , 'Uttar Pradesh' ), ( 'Gwalior' , 'GW' , 'Madhya Pradesh' ), ( 'Banka' , 'BA' , 'Bihar' ), ( 'Mehsana' , 'MA' , 'Gujarat' ), ( 'Firozpur' , 'FI' , 'Punjab' ), ( 'Jhansi' , 'JH' , 'Uttar Pradesh' ), ( 'Pathankot' , 'PA' , 'Punjab' ), ( 'Madhepura' , 'MP' , 'Bihar' ), ( 'Ujjain' , 'UJ' , 'Madhya Pradesh' ), ( 'Kottayam' , 'KT' , 'Kerala' ), ( 'Ganganagar' , 'GA' , 'Rajasthan' ), ( 'Morena' , 'MO' , 'Madhya Pradesh' ), ( 'Jalna' , 'JN' , 'Maharashtra' ), ( 'Chandauli' , 'CD' , 'Uttar Pradesh' ), ( 'Kota' , 'KO' , 'Rajasthan' ), ( 'Dhubri' , 'DB' , 'Assam' ), ( 'Davanagere' , 'DA' , 'Karnataka' ), ( 'Virudhunagar' , 'VR' , 'Tamil Nadu' ), ( 'Palamu' , 'PL' , 'Jharkhand' ), ( 'Haridwar' , 'HA' , 'Uttarakhand' ), ( 'Sonitpur' , 'SO' , 'Assam' ), ( 'Raichur' , 'RA' , 'Karnataka' ), ( 'Pudukkottai' , 'PU' , 'Tamil Nadu' ), ( 'Saharsa' , 'SH' , 'Bihar' ), ( 'Bagalkot' , 'BK' , 'Karnataka' ), ( 'Farrukhabad' , 'FR' , 'Uttar Pradesh' ), ( 'Krishnagiri' , 'KR' , 'Tamil Nadu' ), ( 'Khargone (West Nimar)' , 'WN' , 'Madhya Pradesh' ), ( 'Sonbhadra' , 'SO' , 'Uttar Pradesh' ), ( 'Mainpuri' , 'MP' , 'Uttar Pradesh' ), ( 'Dharwad' , 'DH' , 'Karnataka' ), ( 'Darjeeling' , 'DA' , 'West Bengal' ), ( 'Jyotiba Phule Nagar' , 'JP' , 'Uttar Pradesh' ), ( 'Parbhani' , 'PA' , 'Maharashtra' ), ( 'Jalore' , 'JL' , 'Rajasthan' ), ( 'Jajpur' , 'JP' , 'Odisha' ), ( 'Akola' , 'AK' , 'Maharashtra' ), ( 'Mandya' , 'MA' , 'Karnataka' ), ( 'Kendujhar (Keonjhar)' , 'KJ' , 'Odisha' ), ( 'Banda' , 'BN' , 'Uttar Pradesh' ), ( 'Faridabad' , 'FR' , 'Haryana' ), ( 'Banswara' , 'BN' , 'Rajasthan' ), ( 'Kanpur Dehat (Ramabai Nagar)' , 'KD' , 'Uttar Pradesh' ), ( 'Hanumangarh' , 'HA' , 'Rajasthan' ), ( 'Hassan' , 'HS' , 'Karnataka' ), ( 'Chhatarpur' , 'CT' , 'Madhya Pradesh' ), ( 'Etah' , 'ET' , 'Uttar Pradesh' ), ( 'Jamui' , 'JA' , 'Bihar' ), ( 'Surendranagar' , 'SN' , 'Gujarat' ), ( 'Shimoga' , 'SH' , 'Karnataka' ), ( 'Hissar' , 'HI' , 'Haryana' ), ( 'Thoothukudi' , 'TK' , 'Tamil Nadu' ), ( 'Cachar' , 'CA' , 'Assam' ), ( 'Hazaribag' , 'HA' , 'Jharkhand' ), ( 'Shivpuri' , 'SV' , 'Madhya Pradesh' ), ( 'Namakkal' , 'NM' , 'Tamil Nadu' ), ( 'Sant Kabir Nagar' , 'SK' , 'Uttar Pradesh' ), ( 'East Delhi' , 'ED' , 'Delhi' ), ( 'Buxar' , 'BU' , 'Bihar' ), ( 'Bhind' , 'BD' , 'Madhya Pradesh' ), ( 'Valsad' , 'VL' , 'Gujarat' ), ( 'Balaghat' , 'BL' , 'Madhya Pradesh' ), ( 'Bidar' , 'BD' , 'Karnataka' ), ( 'Alipurduar' , 'AD' , 'West Bengal' ), ( 'Dehradun' , 'DD' , 'Uttarakhand' ), ( 'Puri' , 'PU' , 'Odisha' ), ( 'Barpeta' , 'BA' , 'Assam' ), ( 'Kishanganj' , 'KI' , 'Bihar' ), ( 'Gautam Buddh Nagar' , 'GB' , 'Uttar Pradesh' ), ( 'Dakshin Dinajpur' , 'DD' , 'West Bengal' ), ( 'Jalaun' , 'JL' , 'Uttar Pradesh' ), ( 'Chitradurga' , 'CT' , 'Karnataka' ), ( 'Osmanabad' , 'OS' , 'Maharashtra' ), ( 'Kannauj' , 'KJ' , 'Uttar Pradesh' ), ( 'Khagaria' , 'KH' , 'Bihar' ), ( 'Sangrur' , 'SA' , 'Punjab' ), ( 'Balangir' , 'BL' , 'Odisha' ), ( 'Udham Singh Nagar' , 'US' , 'Uttarakhand' ), ( 'Nandurbar' , 'NB' , 'Maharashtra' ), ( 'Dausa' , 'DA' , 'Rajasthan' ), ( 'Bhiwani' , 'BH' , 'Haryana' ), ( 'Kaimur' , 'KM' , 'Bihar' ), ( 'Janjgir-Champa' , 'JC' , 'Chhattisgarh' ), ( 'Nagapattinam' , 'NG' , 'Tamil Nadu' ), ( 'Ratnagiri' , 'RT' , 'Maharashtra' ), ( 'Haveri district' , 'HV' , 'Karnataka' ), ( 'Kaushambi' , 'KS' , 'Uttar Pradesh' ), ( 'Hoshiarpur' , 'HO' , 'Punjab' ), ( 'Etawah' , 'EW' , 'Uttar Pradesh' ), ( 'Betul' , 'BE' , 'Madhya Pradesh' ), ( 'Kalahandi' , 'KL' , 'Odisha' ), ( 'Hathras (Mahamaya Nagar)' , 'HT' , 'Uttar Pradesh' ), ( 'Dewas' , 'DE' , 'Madhya Pradesh' ), ( 'Sant Ravidas Nagar' , 'SR' , 'Uttar Pradesh' ), ( 'Bharuch' , 'BR' , 'Gujarat' ), ( 'Rajgarh' , 'RG' , 'Madhya Pradesh' ), ( 'Chittorgarh' , 'CT' , 'Rajasthan' ), ( 'Kolar' , 'KL' , 'Karnataka' ), ( 'Rajnandgaon' , 'RN' , 'Chhattisgarh' ), ( 'Jammu' , 'JA' , 'Jammu and Kashmir' ), ( 'Kamrup' , 'KR' , 'Assam' ), ( 'Gurgaon' , 'GU' , 'Haryana' ), ( 'Amreli district' , 'AM' , 'Gujarat' ), ( 'Shajapur' , 'SJ' , 'Madhya Pradesh' ), ( 'Kangra' , 'KA' , 'Himachal Pradesh' ), ( 'Bhadrak' , 'BH' , 'Odisha' ), ( 'Karnal' , 'KR' , 'Haryana' ), ( 'Dharmapuri' , 'DH' , 'Tamil Nadu' ), ( 'West Singhbhum' , 'WS' , 'Jharkhand' ), ( 'Raigarh' , 'RG' , 'Chhattisgarh' ), ( 'Deoghar' , 'DE' , 'Jharkhand' ), ( 'Sonipat' , 'SNP' , 'Haryana' ), ( 'Bargarh (Baragarh)' , 'BR' , 'Odisha' ), ( 'Karauli' , 'KA' , 'Rajasthan' ), ( 'Vidisha' , 'VI' , 'Madhya Pradesh' ), ( 'Ratlam' , 'RL' , 'Madhya Pradesh' ), ( 'Hapur (Panchsheel Nagar)' , 'PN' , 'Uttar Pradesh' ), ( 'Tikamgarh' , 'TI' , 'Madhya Pradesh' ), ( 'Kendrapara' , 'KP' , 'Odisha' ), ( 'Kanshi Ram Nagar' , 'KR' , 'Uttar Pradesh' ), ( 'Tonk' , 'TO' , 'Rajasthan' ), ( 'Bastar' , 'BA' , 'Chhattisgarh' ), ( 'Jhalawar' , 'JW' , 'Rajasthan' ), ( 'Koppal' , 'KP' , 'Karnataka' ), ( 'Dungapur' , 'DU' , 'Rajasthan' ), ( 'Bathinda' , 'BA' , 'Punjab' ), ( 'Gandhinagar' , 'GA' , 'Gujarat' ), ( 'Barwani' , 'BR' , 'Madhya Pradesh' ), ( 'Seoni' , 'SO' , 'Madhya Pradesh' ), ( 'Koraput' , 'KO' , 'Odisha' ), ( 'Auraiya' , 'AU' , 'Uttar Pradesh' ), ( 'Munger' , 'MG' , 'Bihar' ), ( 'Uttara Kannada' , 'UK' , 'Karnataka' ), ( 'Patan' , 'PA' , 'Gujarat' ), ( 'Sivaganga' , 'SI' , 'Tamil Nadu' ), ( 'Mandsaur' , 'MS' , 'Madhya Pradesh' ), ( 'Sawai Madhopur' , 'SM' , 'Rajasthan' ), ( 'Ramanathapuram' , 'RA' , 'Tamil Nadu' ), ( 'Jind' , 'JI' , 'Haryana' ), ( 'Raisen' , 'RS' , 'Madhya Pradesh' ), ( 'Navsari' , 'NV' , 'Gujarat' ), ( 'Dibrugarh' , 'DI' , 'Assam' ), ( 'Garhwa' , 'GA' , 'Jharkhand' ), ( 'Gondia' , 'GO' , 'Maharashtra' ), ( 'Dumka' , 'DU' , 'Jharkhand' ), ( 'Tinsukia' , 'TI' , 'Assam' ), ( 'Godda' , 'GO' , 'Jharkhand' ), ( 'Sehore' , 'SR' , 'Madhya Pradesh' ), ( 'Khandwa (East Nimar)' , 'EN' , 'Madhya Pradesh' ), ( 'Kasaragod' , 'KS' , 'Kerala' ), ( 'Bagpat' , 'BG' , 'Uttar Pradesh' ), ( 'Wardha' , 'WR' , 'Maharashtra' ), ( 'Sirsa' , 'SI' , 'Haryana' ), ( 'Katni' , 'KA' , 'Madhya Pradesh' ), ( 'Angul' , 'AN' , 'Odisha' ), ( 'Srinagar' , 'SR' , 'Jammu and Kashmir' ), ( 'Tiruvarur' , 'TR' , 'Tamil Nadu' ), ( 'Damoh' , 'DM' , 'Madhya Pradesh' ), ( 'Kamrup Metropolitan' , 'KM' , 'Assam' ), ( 'Chikkaballapur' , 'CK' , 'Karnataka' ), ( 'Theni' , 'TH' , 'Tamil Nadu' ), ( 'Hoshangabad' , 'HO' , 'Madhya Pradesh' ), ( 'Guna' , 'GU' , 'Madhya Pradesh' ), ( 'Baran' , 'BR' , 'Rajasthan' ), ( 'Nabarangpur' , 'NB' , 'Odisha' ), ( 'Lalitpur' , 'LA' , 'Uttar Pradesh' ), ( 'Gir Somnath' , '' , 'Gujarat' ), ( 'Karimganj' , 'KR' , 'Assam' ), ( 'Yamuna Nagar' , 'YN' , 'Haryana' ), ( 'Dholpur' , 'DH' , 'Rajasthan' ), ( 'Korba' , 'KB' , 'Chhattisgarh' ), ( 'Panipat' , 'PP' , 'Haryana' ), ( 'Bhandara' , 'BH' , 'Maharashtra' ), ( 'Washim' , 'WS' , 'Maharashtra' ), ( 'Pathanamthitta' , 'PT' , 'Kerala' ), ( 'Dhenkanal' , 'DH' , 'Odisha' ), ( 'Hingoli' , 'HI' , 'Maharashtra' ), ( 'Singrauli' , 'SN' , 'Madhya Pradesh' ), ( 'Udupi' , 'UD' , 'Karnataka' ), ( 'Yadgir' , 'YG' , 'Karnataka' ), ( 'Rajsamand' , 'RA' , 'Rajasthan' ), ( 'Sivasagar' , 'SI' , 'Assam' ), ( 'Sahibganj' , 'SA' , 'Jharkhand' ), ( 'Chikkamagaluru' , 'CK' , 'Karnataka' ), ( 'Ambala' , 'AM' , 'Haryana' ), ( 'Jagatsinghpur' , 'JS' , 'Odisha' ), ( 'Sidhi' , 'SI' , 'Madhya Pradesh' ), ( 'Jehanabad' , 'JE' , 'Bihar' ), ( 'Tarn Taran' , 'TT' , 'Punjab' ), ( 'Shravasti' , 'SV' , 'Uttar Pradesh' ), ( 'Bundi' , 'BU' , 'Rajasthan' ), ( 'Idukki' , 'ID' , 'Kerala' ), ( 'Hamirpur' , 'HM' , 'Uttar Pradesh' ), ( 'Narsinghpur' , 'NA' , 'Madhya Pradesh' ), ( 'Jorhat' , 'JO' , 'Assam' ), ( 'Mewat' , 'MW' , 'Haryana' ), ( 'Ramanagara' , 'RM' , 'Karnataka' ), ( 'Karur' , 'KA' , 'Tamil Nadu' ), ( 'Kaithal' , 'KT' , 'Haryana' ), ( 'Chhota Udaipur' , '' , 'Gujarat' ), ( 'Gadchiroli' , 'GA' , 'Maharashtra' ), ( 'Anantnag' , 'AN' , 'Jammu and Kashmir' ), ( 'Gadag' , 'GA' , 'Karnataka' ), ( 'Shahdol' , 'SH' , 'Madhya Pradesh' ), ( 'Seraikela Kharsawan' , 'SK' , 'Jharkhand' ), ( 'Rohtak' , 'RO' , 'Haryana' ), ( 'Golaghat' , 'GG' , 'Assam' ), ( 'Chandigarh' , 'CH' , 'Chandigarh' ), ( 'Mandla' , 'ML' , 'Madhya Pradesh' ), ( 'Aravalli' , 'AR' , 'Gujarat' ), ( 'Sambalpur' , 'SA' , 'Odisha' ), ( 'Chatra' , 'CH' , 'Jharkhand' ), ( 'Lakhimpur' , 'LA' , 'Assam' ), ( 'Palwal' , 'PW' , 'Haryana' ), ( 'Sirohi' , 'SR' , 'Rajasthan' ), ( 'Mahasamund' , 'MA' , 'Chhattisgarh' ), ( 'Gumla' , 'GU' , 'Jharkhand' ), ( 'Jhabua' , 'JH' , 'Madhya Pradesh' ), ( 'Chamarajnagar' , 'CJ' , 'Karnataka' ), ( 'Panna' , 'PA' , 'Madhya Pradesh' ), ( 'Baramulla' , 'BR' , 'Jammu and Kashmir' ), ( 'Goalpara' , 'GP' , 'Assam' ), ( 'Lakhisarai' , 'LA' , 'Bihar' ), ( 'Mandi' , 'MA' , 'Himachal Pradesh' ), ( 'Mahisagar' , 'MH' , 'Gujarat' ), ( 'Moga' , 'MO' , 'Punjab' ), ( 'Chitrakoot' , 'CT' , 'Uttar Pradesh' ), ( 'Bangalore Rural' , 'BR' , 'Karnataka' ), ( 'Sahibzada Ajit Singh Nagar' , 'SAS' , 'Punjab' ), ( 'Karbi Anglong' , 'KA' , 'Assam' ), ( 'Kurukshetra' , 'KU' , 'Haryana' ), ( 'Nayagarh' , 'NY' , 'Odisha' ), ( 'Rayagada' , 'RA' , 'Odisha' ), ( 'Morbi' , '' , 'Gujarat' ), ( 'Morigaon' , 'MA' , 'Assam' ), ( 'Jhajjar' , 'JH' , 'Haryana' ), ( 'Nainital' , 'NA' , 'Uttarakhand' ), ( 'Baksa' , 'BK' , 'Assam' ), ( 'Ramgarh' , 'RM' , 'Jharkhand' ), ( 'Pondicherry' , 'PO' , 'Puducherry' ), ( 'Fatehabad' , 'FT' , 'Haryana' ), ( 'Mahendragarh' , 'MA' , 'Haryana' ), ( 'West Tripura' , 'WT' , 'Tripura' ), ( 'Darrang' , 'DA' , 'Assam' ), ( 'Sri Muktsar Sahib' , 'MU' , 'Punjab' ), ( 'Pakur' , 'PK' , 'Jharkhand' ), ( 'Rewari' , 'RE' , 'Haryana' ), ( 'Kokrajhar' , 'KK' , 'Assam' ), ( 'North Delhi' , 'NO' , 'Delhi' ), ( 'Mahoba' , 'MH' , 'Uttar Pradesh' ), ( 'Kupwara' , 'KU' , 'Jammu and Kashmir' ), ( 'Pratapgarh' , 'PG' , 'Rajasthan' ), ( 'Jashpur' , 'JA' , 'Chhattisgarh' ), ( 'Sindhudurg' , 'SI' , 'Maharashtra' ), ( 'Ashok Nagar' , 'AS' , 'Madhya Pradesh' ), ( 'Udalguri' , 'UD' , 'Assam' ), ( 'Neemuch' , 'NE' , 'Madhya Pradesh' ), ( 'East Khasi Hills' , 'EK' , 'Meghalaya' ), ( 'North Goa' , 'NG' , 'Goa' ), ( 'Kapurthala' , 'KA' , 'Punjab' ), ( 'Wayanad' , 'WA' , 'Kerala' ), ( 'Shimla' , 'SH' , 'Himachal Pradesh' ), ( 'Tapi' , 'TA' , 'Gujarat' ), ( 'Dhamtari' , 'DH' , 'Chhattisgarh' ), ( 'Jamtara' , 'JA' , 'Jharkhand' ), ( 'Datia' , 'DT' , 'Madhya Pradesh' ), ( 'Nalbari' , 'NL' , 'Assam' ), ( 'Mansa' , 'MA' , 'Punjab' ), ( 'Burhanpur' , 'BU' , 'Madhya Pradesh' ), ( 'Devbhoomi Dwarka' , '' , 'Gujarat' ), ( 'Ariyalur' , 'AY' , 'Tamil Nadu' ), ( 'Anuppur' , 'AP' , 'Madhya Pradesh' ), ( 'Kanker' , 'KK' , 'Chhattisgarh' ), ( 'Badgam' , 'BD' , 'Jammu and Kashmir' ), ( 'Nilgiris' , 'NI' , 'Tamil Nadu' ), ( 'Bongaigaon' , 'BO' , 'Assam' ), ( 'Kandhamal' , 'KN' , 'Odisha' ), ( 'Alirajpur' , 'AL' , 'Madhya Pradesh' ), ( 'Latehar' , 'LA' , 'Jharkhand' ), ( 'Koderma' , 'KO' , 'Jharkhand' ), ( 'Dindori' , 'DI' , 'Madhya Pradesh' ), ( 'Arwal' , 'AR' , 'Bihar' ), ( 'Dhemaji' , 'DM' , 'Assam' ), ( 'Sheopur' , 'SP' , 'Madhya Pradesh' ), ( 'Pauri Garhwal' , 'PG' , 'Uttarakhand' ), ( 'Rupnagar' , 'RU' , 'Punjab' ), ( 'Jaisalmer' , 'JS' , 'Rajasthan' ), ( 'Surajpur' , 'SJ' , 'Chhattisgarh' ), ( 'Hailakandi' , 'HA' , 'Assam' ), ( 'Koriya' , 'KJ' , 'Chhattisgarh' ), ( 'Sheohar' , 'SO' , 'Bihar' ), ( 'Botad' , '' , 'Gujarat' ), ( 'Subarnapur (Sonepur)' , 'SO' , 'Odisha' ), ( 'Umaria' , 'UM' , 'Madhya Pradesh' ), ( 'West Garo Hills' , 'WG' , 'Meghalaya' ), ( 'South Goa' , 'SG' , 'Goa' ), ( 'Sheikhpura' , 'SP' , 'Bihar' ), ( 'Almora' , 'AL' , 'Uttarakhand' ), ( 'Rajouri' , 'RA' , 'Jammu and Kashmir' ), ( 'Faridkot' , 'FR' , 'Punjab' ), ( 'Tehri Garhwal' , 'TG' , 'Uttarakhand' ), ( 'Kathua' , 'KT' , 'Jammu and Kashmir' ), ( 'Shahid Bhagat Singh Nagar' , 'PB' , 'Punjab' ), ( 'Malkangiri' , 'ML' , 'Odisha' ), ( 'Nuapada' , 'NU' , 'Odisha' ), ( 'Fatehgarh Sahib' , 'FT' , 'Punjab' ), ( 'Simdega' , 'SI' , 'Jharkhand' ), ( 'Barnala' , 'BNL' , 'Punjab' ), ( 'Narmada' , 'NR' , 'Gujarat' ), ( 'Porbandar' , 'PO' , 'Gujarat' ), ( 'Kabirdham (formerly Kawardha)' , 'KW' , 'Chhattisgarh' ), ( 'Jharsuguda' , 'JH' , 'Odisha' ), ( 'Central Delhi' , 'CD' , 'Delhi' ), ( 'Solan' , 'SO' , 'Himachal Pradesh' ), ( 'Gajapati' , 'GP' , 'Odisha' ), ( 'Harda' , 'HA' , 'Madhya Pradesh' ), ( 'Pulwama' , 'PU' , 'Jammu and Kashmir' ), ( 'Perambalur' , 'PE' , 'Tamil Nadu' ), ( 'Panchkula' , 'PK' , 'Haryana' ), ( 'Udhampur' , 'UD' , 'Jammu and Kashmir' ), ( 'Kodagu' , 'KD' , 'Karnataka' ), ( 'Dantewada' , 'DA' , 'Chhattisgarh' ), ( 'Khunti' , 'KH' , 'Jharkhand' ), ( 'Sirmaur' , 'SI' , 'Himachal Pradesh' ), ( 'Una' , 'UNA' , 'Himachal Pradesh' ), ( 'Chamba' , 'CH' , 'Himachal Pradesh' ), ( 'Imphal West' , 'WI' , 'Manipur' ), ( 'Pithoragarh' , 'PI' , 'Uttarakhand' ), ( 'Sepahijala' , 'SP' , 'Tripura' ), ( 'Chirang' , 'CH' , 'Assam' ), ( 'Poonch' , 'PO' , 'Jammu and Kashmir' ), ( 'Lohardaga' , 'LO' , 'Jharkhand' ), ( 'Hamirpur' , 'HA' , 'Himachal Pradesh' ), ( 'Imphal East' , 'EI' , 'Manipur' ), ( 'Boudh (Bauda)' , 'BD' , 'Odisha' ), ( 'Kullu' , 'KU' , 'Himachal Pradesh' ), ( 'Gomati' , 'GM' , 'Tripura' ), ( 'South Tripura' , 'ST' , 'Tripura' ), ( 'Kulgam' , 'KG' , 'Jammu and Kashmir' ), ( 'Surguja' , 'SJ' , 'Chhattisgarh' ), ( 'Thoubal' , 'TH' , 'Manipur' ), ( 'North Tripura' , 'NT' , 'Tripura' ), ( 'Tuensang' , 'TU' , 'Mizoram' ), ( 'Doda' , 'DO' , 'Jammu and Kashmir' ), ( 'Aizawl' , 'AI' , 'Mizoram' ), ( 'Chamoli' , 'CL' , 'Uttarakhand' ), ( 'West Khasi Hills' , 'WK' , 'Meghalaya' ), ( 'Bandipora' , 'BPR' , 'Jammu and Kashmir' ), ( 'Bilaspur' , 'BI' , 'Himachal Pradesh' ), ( 'Dimapur' , 'DI' , 'Mizoram' ), ( 'Dhalai' , 'DH' , 'Tripura' ), ( 'Senapati' , 'SE' , 'Manipur' ), ( 'Dadra and Nagar Haveli' , 'DN' , 'Dadra and Nagar Haveli' ), ( 'Uttarkashi' , 'UT' , 'Uttarakhand' ), ( 'Khowai' , 'KH' , 'Tripura' ), ( 'Samba' , 'SB' , 'Jammu and Kashmir' ), ( 'East Garo Hills' , 'EG' , 'Meghalaya' ), ( 'Reasi' , 'RS' , 'Jammu and Kashmir' ), ( 'Debagarh (Deogarh)' , 'DE' , 'Odisha' ), ( 'Ganderbal' , 'GB' , 'Jammu and Kashmir' ), ( 'Ramban' , 'RB' , 'Jammu and Kashmir' ), ( 'East Sikkim' , 'ES' , 'Sikkim' ), ( 'Unokoti' , 'UK' , 'Tripura' ), ( 'Churachandpur' , 'CC' , 'Manipur' ), ( 'West Jaintia Hills' , 'WG' , 'Meghalaya' ), ( 'Kohima' , 'KO' , 'Mizoram' ), ( 'Shopian' , 'SH' , 'Jammu and Kashmir' ), ( 'Bageshwar' , 'BA' , 'Uttarakhand' ), ( 'Mon' , 'MN' , 'Mizoram' ), ( 'Champawat' , 'CP' , 'Uttarakhand' ), ( 'Ri Bhoi' , 'RB' , 'Meghalaya' ), ( 'Bijapur' , 'BJ' , 'Chhattisgarh' ), ( 'Sukma' , 'SK' , 'Chhattisgarh' ), ( 'Bishnupur' , 'BI' , 'Manipur' ), ( 'South Andaman' , 'SA' , 'Andaman and Nicobar' ), ( 'Rudraprayag' , 'RP' , 'Uttarakhand' ), ( 'Kishtwar' , 'KW' , 'Jammu and Kashmir' ), ( 'Dang' , 'DG' , 'Gujarat' ), ( 'Dima Hasao' , 'NC' , 'Assam' ), ( 'Karaikal' , 'KA' , 'Puducherry' ), ( 'Mokokchung' , 'MK' , 'Mizoram' ), ( 'Daman' , 'DA' , 'Daman and Diu' ), ( 'Ukhrul' , 'UK' , 'Manipur' ), ( 'Papum Pare' , 'PA' , 'Arunachal Pradesh' ), ( 'Wokha' , 'WO' , 'Mizoram' ), ( 'Peren' , 'PE' , 'Mizoram' ), ( 'Phek' , 'PH' , 'Mizoram' ), ( 'Lunglei' , 'LU' , 'Mizoram' ), ( 'Changlang' , 'CH' , 'Arunachal Pradesh' ), ( 'Leh' , 'LE' , 'Jammu and Kashmir' ), ( 'South Sikkim' , 'SS' , 'Sikkim' ), ( 'Lohit' , 'EL' , 'Arunachal Pradesh' ), ( 'Chandel' , 'CD' , 'Manipur' ), ( 'Kargil' , 'KR' , 'Jammu and Kashmir' ), ( 'South Garo Hills' , 'SG' , 'Meghalaya' ), ( 'Zunheboto' , 'ZU' , 'Mizoram' ), ( 'Narayanpur' , 'NR' , 'Chhattisgarh' ), ( 'Tamenglong' , 'TA' , 'Manipur' ), ( 'West Sikkim' , 'WS' , 'Sikkim' ), ( 'New Delhi' , 'ND' , 'Delhi' ), ( 'Champhai' , 'CH' , 'Mizoram' ), ( 'East Jaintia Hills' , '' , 'Meghalaya' ), ( 'North Garo Hills' , '' , 'Meghalaya' ), ( 'Lawngtlai' , 'LA' , 'Mizoram' ), ( 'West Siang' , 'WS' , 'Arunachal Pradesh' ), ( 'Tirap' , 'TI' , 'Arunachal Pradesh' ), ( 'South West Khasi Hills' , '' , 'Meghalaya' ), ( 'North and Middle Andaman' , 'NA' , 'Andaman and Nicobar' ), ( 'East Siang' , 'ES' , 'Arunachal Pradesh' ), ( 'Kurung Kumey' , 'KK' , 'Arunachal Pradesh' ), ( 'West Kameng' , 'WK' , 'Arunachal Pradesh' ), ( 'Mamit' , 'MA' , 'Mizoram' ), ( 'Kinnaur' , 'KI' , 'Himachal Pradesh' ), ( 'Upper Subansiri' , 'UB' , 'Arunachal Pradesh' ), ( 'Kolasib' , 'KO' , 'Mizoram' ), ( 'Lower Subansiri' , 'LB' , 'Arunachal Pradesh' ), ( 'East Kameng' , 'EK' , 'Arunachal Pradesh' ), ( 'Kiphire' , 'KI' , 'Mizoram' ), ( 'Serchhip' , 'SE' , 'Mizoram' ), ( 'Lakshadweep' , 'LD' , 'Lakshadweep' ), ( 'Saiha' , 'SA' , 'Mizoram' ), ( 'Yanam' , 'YA' , 'Puducherry' ), ( 'Lower Dibang Valley' , 'DV' , 'Arunachal Pradesh' ), ( 'Diu' , 'DI' , 'Daman and Diu' ), ( 'Longleng' , 'LO' , 'Mizoram' ), ( 'Tawang' , 'TA' , 'Arunachal Pradesh' ), ( 'North Sikkim' , 'NS' , 'Sikkim' ), ( 'Mahe' , 'MA' , 'Puducherry' ), ( 'Nicobar' , 'NI' , 'Andaman and Nicobar' ), ( 'Upper Siang' , 'US' , 'Arunachal Pradesh' ), ( 'Lahaul and Spiti' , 'LS' , 'Himachal Pradesh' ), ( 'Anjaw' , 'AJ' , 'Arunachal Pradesh' ), ( 'Dibang Valley' , 'UD' , 'Arunachal Pradesh' ), ( 'Fazilka' , 'FA' , 'Punjab' ), ( 'Shamli' , 'SH' , 'Uttar Pradesh' ), ( 'Balrampur' , '' , 'Chhattisgarh' ), ( 'Bemetara' , '' , 'Chhattisgarh' ), ( 'Palghar' , '-' , 'Maharashtra' ), ( 'Longding' , 'LD' , 'Arunachal Pradesh' ), ( 'Balod' , '' , 'Chhattisgarh' ), ( 'Baloda Bazar' , '' , 'Chhattisgarh' ), ( 'Gariaband' , '' , 'Chhattisgarh' ), ( 'Kondagaon' , '' , 'Chhattisgarh' ), ( 'Mungeli' , '' , 'Chhattisgarh' ), ( 'Shahdara' , '' , 'Delhi' ), ( 'South East Delhi' , '' , 'Delhi' ), ( 'Agar' , 'AG' , 'Madhya Pradesh' ), ( 'South West Garo Hills' , '' , 'Meghalaya' ), ( 'Amethi (Chhatrapati Shahuji Maharaj Nagar)' , 'CS' , 'Uttar Pradesh' )

Suraj Kumar · Answer

Dear Kishan you can find the attachment in for Indian district in both excel as well as MS SQL. You can run the sql and get the result for district list of India.

please provide india districts List in ms SQl

Answers (2)