SQL exercises

February 18, 04:05 MSK

SQL Exercises is intended for acquiring good practical experience, which is focused on data operation, namely on SQL DML. Certain exercises for beginners are provided on the site, they are supplied with the necessary reference source on SQL syntax with a great number of examples. Apart from them, 3 rating stages are suggested, they are aimed at testing of specialists and their certification. The source is absolutely free of charge, and the certificate purchase has a voluntary basis.
NOTE: Your browser should support Cookies and Javascript to provide correct usage of this site. If you use content filter, it should allow opening child windows to explore help pages.

Ratings

  • Top 100
  • Top 100 on latest exercises
  • "Liberal" rating
  • Olympic rating
  • TOP 100 of Learning Stage
  • Rating by summation of ranks
  • Top 10 (photos)
  • Last-week results
  • Rating of second-stage exercises (average)
  • Rating of 2nd-stage exercises (median)
  • Author's rating  • 2nd stage rating up to exercise:
   enter No 
  • Rating on the exercise:
   enter No
  • Optimistic rating
   enter factor

Statistics

  • Today statistics
  • Site's old residents
  • Recent leaders activity
  • Сhanges in exercises' TOP 10
  • Results' chart

SQL exercises

  • Site rules
  • SELECT (learning stage)
  • SELECT (learning stage,
      choosing DBMS)
  • SELECT (rating stages)
  • DML 
  • Transact-SQL tests
  • Data simulation
  • Visual simulation (painting)
  • Exercises voting

Forums

  • Learning stage
  • Rating stages
  • Favorites
  • Search
  • Blogs

Certification

  • Certified professionals
  • Statistics
  • Statistics over regions (map)
  • Confirm certificate

HELP

Query optimization

For employers

Support SQL-EX.RU

Карниз для ванной cersanit
Доставка. От производителя! Карнизы для ванной. Купить здесь
goodhome.shop
Сертифицированные запчасти land Rover
Уникальная система кроссов, позволяющая подобрать запчасть на любой бюджет
autodoc.ru

Top 100 results shown on the exercise #81

No	Surname	Seconds	dd hh:mm:ss	Date
1	Sal'nikov S.A. ($erges)	4	0 00:00:04	2008-05-12
2	Tot'myanin S.A. (SCAT)	440	0 00:07:20	2009-01-23
3	Yatsuk A.A. (Faust_zp)	903	0 00:15:03	2009-06-18
4	Mullakhanov R.Kh. (rem)	1124	0 00:18:44	2008-11-05
5	Korolev A. (Gluck)	1140	0 00:19:00	2010-06-04
6	Donskoj A.V. (dirty)	1191	0 00:19:51	2009-12-19
7	Sanko A. (count)	1229	0 00:20:29	2010-04-19
8	Tarasenkov A.V. (tarasenkov)	1402	0 00:23:22	2012-08-30
9	Tarasevich S. (Aprilfire)	1490	0 00:24:50	2012-07-12
10	Tsarapkin D.I. (Tsarapkin)	1534	0 00:25:34	2015-12-09
11	Suprun D. (TimonSP)	1535	0 00:25:35	2008-09-23
12	S'edin G. (HooliGUN)	1545	0 00:25:45	2011-11-24
13	Lyadov S.A. (Serg Alex Lad)	1563	0 00:26:03	2017-06-28
14	Grischenko S.V. (SergeyKiev)	1572	0 00:26:12	2011-04-15
15	Fogel' A. (Hockmoon)	1573	0 00:26:13	2015-08-12
16	Borisenkov D.V. (xuser)	1606	0 00:26:46	2008-10-11
17	Makarov S.S. (qwerty12345678zxcvb)	1608	0 00:26:48	2017-11-16
18	pal (pal-)	1609	0 00:26:49	2012-01-04
19	Borisov E.V. (Eugene_B)	1619	0 00:26:59	2011-09-16
20	Timchenko S. (timka__s)	1634	0 00:27:14	2011-11-26
21	Aleksandrov I. (alexi)	1655	0 00:27:35	2010-06-28
22	Sorokin D.Yu. (cth)	1744	0 00:29:04	2018-06-28
23	Movlyanov A.P. (Oct)	1778	0 00:29:38	2013-08-01
24	Krasavina O.V. (Chatte)	1822	0 00:30:22	2017-03-27
25	Grecha (grecha)	1823	0 00:30:23	2013-11-24
26	Gulyaev S. (sergey.g)	1823	0 00:30:23	2016-08-26
27	Bulanov P.A. (rage)	1837	0 00:30:37	2008-07-18
28	Gladkikh D.S. (ZlobnYJ_DobR)	1845	0 00:30:45	2009-01-26
29	Murashkin I.V. (lepton)	1879	0 00:31:19	2008-07-08
30	Rakovich A. (Lohmatyi)	1899	0 00:31:39	2009-01-30
31	Iljy (iljy)	1903	0 00:31:43	2009-08-07
32	Vanteev A.G. (vanteevart)	1908	0 00:31:48	2014-11-28
33	Basharin E. (eaniconer)	1924	0 00:32:04	2017-04-26
34	Yuldashev M.R. (Snowbear)	1945	0 00:32:25	2008-06-08
35	Kholtygin S.A. (s.kholtygin)	1946	0 00:32:26	2011-07-22
36	Borzov V.V. (simulacrum)	1950	0 00:32:30	2012-01-03
37	Yunusov R.N. (Ruslan1707)	1970	0 00:32:50	2010-11-03
38	Kirshanskij S.P. (Vishnya)	1973	0 00:32:53	2009-07-22
39	Sidorov A.V. (OPM)	2054	0 00:34:14	2009-12-23
40	Derzhal'tsev V.A. (MadVet)	2065	0 00:34:25	2008-05-14
41	Yakimansky V. (axfreelancer)	2101	0 00:35:01	2008-08-26
42	Tikhanov (tikhanov)	2109	0 00:35:09	2014-06-05
43	Kolos O. (the_bald)	2168	0 00:36:08	2015-02-17
44	Sadovnikov A.N. (raul)	2169	0 00:36:09	2010-10-20
45	Sergeev D.A. (Ethereal)	2189	0 00:36:29	2011-05-02
46	Ilyasov V. (VadimI)	2202	0 00:36:42	2016-11-01
47	Egorov Yu.A. (Yury Egorov)	2221	0 00:37:01	2011-08-30
48	Osin V. (anyman1979)	2262	0 00:37:42	2017-10-29
49	Gafarov A.Kh. (toZkopan)	2288	0 00:38:08	2014-01-16
50	Terbushev A.P. (terX)	2292	0 00:38:12	2016-09-21
51	Sokolov A.S. (WFR)	2343	0 00:39:03	2008-12-06
52	Vil'danov M. (mar_vi)	2353	0 00:39:13	2008-07-02
53	Utyonkov M.N. (=Maxim=)	2360	0 00:39:20	2011-08-03
54	Tarshin S.N. (tsn)	2407	0 00:40:07	2011-10-21
55	Pesterev A. (PandNsk)	2437	0 00:40:37	2008-09-11
56	Karasyova N.V. (vlksm)	2455	0 00:40:55	2008-05-10
57	Burmistrov V.V. (Razorkell)	2477	0 00:41:17	2019-09-03
58	Bespyatov A. (lelik_b)	2494	0 00:41:34	2010-09-24
59	Fursin A.N. (Vendigo)	2517	0 00:41:57	2008-06-24
60	Selivyorstova N. (3N)	2522	0 00:42:02	2018-12-10
61	Korobov I.V. (ivan.korobov)	2566	0 00:42:46	2008-05-12
62	Ol'shanskij A.V. (alx_ol)	2580	0 00:43:00	2008-11-17
63	Tarasenko D.V. (tdv)	2582	0 00:43:02	2014-10-17
64	Simakin V.A. (Rybak)	2597	0 00:43:17	2009-03-17
65	Mityurin V. (mitvol)	2604	0 00:43:24	2017-06-13
66	Shuravin E.P. (dumkan)	2625	0 00:43:45	2016-01-10
67	Filonov Yu.K. (YuFi)	2639	0 00:43:59	2014-03-03
68	Ovsyannikov A.S. (lnl122)	2656	0 00:44:16	2015-09-07
69	Stsiborskij S.S. (Sergey Stsiborsky)	2658	0 00:44:18	2015-02-24
70	Telyukh V. (LoGizMo)	2675	0 00:44:35	2013-04-15
71	Vyazovetskov A.S. (alex_v)	2680	0 00:44:40	2012-05-04
72	Pankin B. (Boris Pankin)	2697	0 00:44:57	2013-09-28
73	Vakhrameev A. (WY)	2721	0 00:45:21	2011-05-29
74	Tainstvennyj A. (Astralis)	2724	0 00:45:24	2011-08-14
75	Pavlenko D.K. (Fantast)	2784	0 00:46:24	2009-03-04
76	Voevutskij S.A. (SergLK)	2789	0 00:46:29	2009-09-17
77	Smirnov G.S. (X-wave)	2810	0 00:46:50	2011-11-24
78	Sivoglazov M.A. (Gaizenberg)	2834	0 00:47:14	2014-01-09
79	Frolov (simple09)	2842	0 00:47:22	2010-09-23
80	Ioffe Yu.A. (Iura__)	2880	0 00:48:00	2013-07-16
81	Pavlov A.V. (Anton)	2898	0 00:48:18	2010-12-22
82	Alekseev A.O. (Toxa Moskit)	2913	0 00:48:33	2008-05-25
83	Dushevski (exek)	2967	0 00:49:27	2013-01-10
84	Kozyr' D.V. (the_kodv)	3045	0 00:50:45	2013-04-24
85	Vojnov P.E. (paparome)	3061	0 00:51:01	2008-05-12
86	Rustem (Chesnok)	3065	0 00:51:05	2010-01-29
87	Ovsyankin V.S. (Kazaam)	3066	0 00:51:06	2010-07-28
88	Deev A.V. (pickman)	3081	0 00:51:21	2011-04-11
89	Kashkarov D.S. (frosten)	3084	0 00:51:24	2011-03-25
90	Kuchmel' B.V. (Boris13)	3099	0 00:51:39	2011-11-08
91	Shaymardanov M.M. (xLiSPirit)	3105	0 00:51:45	2011-10-24
92	LisperWhisper (LisperWhisper)	3139	0 00:52:19	2012-12-02
93	Pokhmelkin A.Yu. (Corleone)	3167	0 00:52:47	2009-05-08
94	Zajtsev V.S. (Sleeping)	3183	0 00:53:03	2013-10-30
95	Vinogradov I.N. (Mammoth)	3236	0 00:53:56	2011-07-18
96	Titovskij P.S. (kli3ma)	3248	0 00:54:08	2011-06-01
97	b S.V. (koyaaniqatsi)	3270	0 00:54:30	2011-04-23
98	Tal'ko (edgt)	3286	0 00:54:46	2015-04-20
99	iglbeat (iglbeat)	3300	0 00:55:00	2008-05-21

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References