여러분이 사용하고 계신 브라우저는 HTML5를 지원하지 않기 때문에 몇몇 요소가 제대로 보이도록 JScript를 사용하고 있습니다. 하지만 여러분의 브라우저 설정에서 스크립트 기능이 꺼져있으므로, 현재 페이지를 제대로 확인하시려면 스크립트 기능을 켜주셔야 합니다. SQL - 참조 - 키워드 - ASC
SQL – 참조 – 키워드 – ASC
4주전 작성
3주전 수정

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
참고
Mingg`s Diary
밍구
공부 목적 블로그