SQL - 참조 - 키워드 - ASC

ASC

ASC 명령은 반환된 데이터를 오름차순으로 정렬하는 데 사용된다.

예시

“CustomerName” 열을 기준으로 정렬된 “Customers” 테이블의 모든 열을 선택한다.

SELECT * FROM Customers
ORDER BY CustomerName ASC;

기본 예시

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country	Email
1	Alfreds Futterkiste	Maria Anders	Obere Str. 57	Berlin	12209	Germany	null
2	Ana Trujillo Emparedados y helados	Ana Trujillo	Avda. de la Constitución 2222	México D.F.	05021	Mexico	null
3	Antonio Moreno Taquería	Antonio Moreno	Mataderos 2312	México D.F.	05023	Mexico	null
4	Around the Horn	Thomas Hardy	120 Hanover Sq.	London	WA1 1DP	UK	null
11	B’s Beverages	Victoria Ashworth	Fauntleroy Circus	London	EC2 5NT	UK	null
5	Berglunds snabbköp	Christina Berglund	Berguvsvägen 8	Luleå	S-958 22	Sweden	null
6	Blauer See Delikatessen	Hanna Moos	Forsterstr. 57	Mannheim	68306	Germany	null
7	Blondel père et fils	Frédérique Citeaux	24, place Kléber	Strasbourg	67000	France	null
9	Bon app’	Laurence Lebihans	12, rue des Bouchers	Marseille	13008	France	null
10	Bottom-Dollar Marketse	Elizabeth Lincoln	23 Tsawassen Blvd.	Tsawassen	T2F 8M4	Canada	null
8	Bólido Comidas preparadas	Martín Sommer	C/ Araquil, 67	Madrid	28023	Spain	null
12	Cactus Comidas para llevar	Patricio Simpson	Cerrito 333	Buenos Aires	1010	Argentina	null
13	Centro comercial Moctezuma	Francisco Chang	Sierras de Granada 9993	México D.F.	05022	Mexico	null
14	Chop-suey Chinese	Yang Wang	Hauptstr. 29	Bern	3012	Switzerland	null
15	Comércio Mineiro	Pedro Afonso	Av. dos Lusíadas, 23	São Paulo	05432-043	Brazil	null
16	Consolidated Holdings	Elizabeth Brown	Berkeley Gardens 12 Brewery	London	WX1 6LT	UK	null
86	Die Wandernde Kuh	Rita Müller	Adenauerallee 900	Stuttgart	70563	Germany	null
17	Drachenblut Delikatessend	Sven Ottlieb	Walserweg 21	Aachen	52066	Germany	null
18	Du monde entier	Janine Labrune	67, rue des Cinquante Otages	Nantes	44000	France	null
19	Eastern Connection	Ann Devon	35 King George	London	WX3 6FW	UK	null
20	Ernst Handel	Roland Mendel	Kirchgasse 6	Graz	8010	Austria	null
22	FISSA Fabrica Inter. Salchichas S.A.	Diego Roel	C/ Moralzarzal, 86	Madrid	28034	Spain	null
21	Familia Arquibaldo	Aria Cruz	Rua Orós, 92	São Paulo	05442-030	Brazil	null
23	Folies gourmandes	Martine Rancé	184, chaussée de Tournai	Lille	59000	France	null
24	Folk och fä HB	Maria Larsson	Åkergatan 24	Bräcke	S-844 67	Sweden	null
26	France restauration	Carine Schmitt	54, rue Royale	Nantes	44000	France	null
27	Franchi S.p.A.	Paolo Accorti	Via Monte Bianco 34	Torino	10100	Italy	null
25	Frankenversand	Peter Franken	Berliner Platz 43	München	80805	Germany	null
28	Furia Bacalhau e Frutos do Mar	Lino Rodriguez	Jardim das rosas n. 32	Lisboa	1675	Portugal	null
33	GROSELLA-Restaurante	Manuel Pereira	5ª Ave. Los Palos Grandes	Caracas	1081	Venezuela	null
29	Galería del gastrónomo	Eduardo Saavedra	Rambla de Cataluña, 23	Barcelona	08022	Spain	null
30	Godos Cocina Típica	José Pedro Freyre	C/ Romero, 33	Sevilla	41101	Spain	null
31	Gourmet Lanchonetes	André Fonseca	Av. Brasil, 442	Campinas	04876-786	Brazil	null
32	Great Lakes Food Market	Howard Snyder	2732 Baker Blvd.	Eugene	97403	USA	null
35	HILARIÓN-Abastos	Carlos Hernández	Carrera 22 con Ave. Carlos Soublette #8-35	San Cristóbal	5022	Venezuela	null
34	Hanari Carnes	Mario Pontes	Rua do Paço, 67	Rio de Janeiro	05454-876	Brazil	null
36	Hungry Coyote Import Store	Yoshi Latimer	City Center Plaza 516 Main St.	Elgin	97827	USA	null
37	Hungry Owl All-Night Grocers	Patricia McKenna	8 Johnstown Road	Cork		Ireland	null
38	Island Trading	Helen Bennett	Garden House Crowther Way	Cowes	PO31 7PJ	UK	null
39	Königlich Essen	Philip Cramer	Maubelstr. 90	Brandenburg	14776	Germany	null
46	LILA-Supermercado	Carlos González	Carrera 52 con Ave. Bolívar #65-98 Llano Largo	Barquisimeto	3508	Venezuela	null
47	LINO-Delicateses	Felipe Izquierdo	Ave. 5 de Mayo Porlamar	I. de Margarita	4980	Venezuela	null
40	La corne d’abondance	Daniel Tonini	67, avenue de l’Europe	Versailles	78000	France	null
41	La maison d’Asie	Annette Roulet	1 rue Alsace-Lorraine	Toulouse	31000	France	null
42	Laughing Bacchus Wine Cellars	Yoshi Tannamuri	1900 Oak St.	Vancouver	V3F 2K1	Canada	null
43	Lazy K Kountry Store	John Steel	12 Orchestra Terrace	Walla Walla	99362	USA	null
44	Lehmanns Marktstand	Renate Messner	Magazinweg 7	Frankfurt a.M.	60528	Germany	null
45	Let’s Stop N Shop	Jaime Yorres	87 Polk St. Suite 5	San Francisco	94117	USA	null
48	Lonesome Pine Restaurant	Fran Wilson	89 Chiaroscuro Rd.	Portland	97219	USA	null
49	Magazzini Alimentari Riuniti	Giovanni Rovelli	Via Ludovico il Moro 22	Bergamo	24100	Italy	null
50	Maison Dewey	Catherine Dewey	Rue Joseph-Bens 532	Bruxelles	B-1180	Belgium	null
52	Morgenstern Gesundkost	Alexander Feuer	Heerstr. 22	Leipzig	04179	Germany	null
51	Mère Paillarde	Jean Fresnière	43 rue St. Laurent	Montréal	H1J 1C3	Canada	null
53	North/South	Simon Crowther	South House 300 Queensbridge	London	SW7 1RZ	UK	null
54	Océano Atlántico Ltda.	Yvonne Moncada	Ing. Gustavo Moncada 8585 Piso 20-A	Buenos Aires	1010	Argentina	null
55	Old World Delicatessen	Rene Phillips	2743 Bering St.	Anchorage	99508	USA	null
56	Ottilies Käseladen	Henriette Pfalzheim	Mehrheimerstr. 369	Köln	50739	Germany	null
57	Paris spécialités	Marie Bertrand	265, boulevard Charonne	Paris	75012	France	null
58	Pericles Comidas clásicas	Guillermo Fernández	Calle Dr. Jorge Cash 321	México D.F.	05033	Mexico	null
59	Piccolo und mehr	Georg Pipps	Geislweg 14	Salzburg	5020	Austria	null
60	Princesa Isabel Vinhoss	Isabel de Castro	Estrada da saúde n. 58	Lisboa	1756	Portugal	null
63	QUICK-Stop	Horst Kloss	Taucherstraße 10	Cunewalde	01307	Germany	null
61	Que Delícia	Bernardo Batista	Rua da Panificadora, 12	Rio de Janeiro	02389-673	Brazil	null
62	Queen Cozinha	Lúcia Carvalho	Alameda dos Canàrios, 891	São Paulo	05487-020	Brazil	null
64	Rancho grande	Sergio Gutiérrez	Av. del Libertador 900	Buenos Aires	1010	Argentina	null
65	Rattlesnake Canyon Grocery	Paula Wilson	2817 Milton Dr.	Albuquerque	87110	USA	null
66	Reggiani Caseifici	Maurizio Moroni	Strada Provinciale 124	Reggio Emilia	42100	Italy	null
67	Ricardo Adocicados	Janete Limeira	Av. Copacabana, 267	Rio de Janeiro	02389-890	Brazil	null
68	Richter Supermarkt	Michael Holz	Grenzacherweg 237	Genève	1203	Switzerland	null
69	Romero y tomillo	Alejandra Camino	Gran Vía, 1	Madrid	28001	Spain	null
70	Santé Gourmet	Jonas Bergulfsen	Erling Skakkes gate 78	Stavern	4110	Norway	null
71	Save-a-lot Markets	Jose Pavarotti	187 Suffolk Ln.	Boise	83720	USA	null
72	Seven Seas Imports	Hari Kumar	90 Wadhurst Rd.	London	OX15 4NB	UK	null
73	Simons bistro	Jytte Petersen	Vinbæltet 34	København	1734	Denmark	null
75	Split Rail Beer & Ale	Art Braunschweiger	P.O. Box 555	Lander	82520	USA	null
74	Spécialités du monde	Dominique Perrier	25, rue Lauriston	Paris	75016	France	null
76	Suprêmes délices	Pascale Cartrain	Boulevard Tirou, 255	Charleroi	B-6000	Belgium	null
77	The Big Cheese	Liz Nixon	89 Jefferson Way Suite 2	Portland	97201	USA	null
78	The Cracker Box	Liu Wong	55 Grizzly Peak Rd.	Butte	59801	USA	null
79	Toms Spezialitäten	Karin Josephs	Luisenstr. 48	Münster	44087	Germany	null
80	Tortuga Restaurante	Miguel Angel Paolino	Avda. Azteca 123	México D.F.	05033	Mexico	null
81	Tradição Hipermercados	Anabela Domingues	Av. Inês de Castro, 414	São Paulo	05634-030	Brazil	null
82	Trail’s Head Gourmet Provisioners	Helvetius Nagy	722 DaVinci Blvd.	Kirkland	98034	USA	null
83	Vaffeljernet	Palle Ibsen	Smagsløget 45	Århus	8200	Denmark	null
84	Victuailles en stock	Mary Saveley	2, rue du Commerce	Lyon	69004	France	null
85	Vins et alcools Chevalier	Paul Henriot	59 rue de l’Abbaye	Reims	51100	France	null
87	Wartian Herkku	Pirkko Koskitalo	Torikatu 38	Oulu	90110	Finland	null
88	Wellington Importadora	Paula Parente	Rua do Mercado, 12	Resende	08737-363	Brazil	null
89	White Clover Markets	Karl Jablonski	305 – 14th Ave. S. Suite 3B	Seattle	98128	USA	null
90	Wilman Kala	Matti Karttunen	Keskuskatu 45	Helsinki	21240	Finland	null
91	Wolski	Zbyszek	ul. Filtrowa 68	Walla	01-012	Poland	null

참고

W3C School - SQL Add Keywords

W3C School - SQL Tutorial

Mingg`s Diary

밍구

공부 목적 블로그

https://maz.kr

모든 포스트 보기

ASC

예시

참고

댓글 답글 취소