Ba da Gudummawa
Nemo tambayoyi…
⌘
K
English
Tiếng Việt
日本語
한국어
Español
العربية
বাংলা
čeština
Dansk
Deutsch
Ελληνικά
Suomi
Français
Gaeilge
ગુજરાતી
Hausa
हिन्दी
Hrvatski
Magyar
Bahasa Indonesia
Italiano
Basa Jawa
ქართული
Lietuvių
मराठी
Melayu
Malti
नेपाली
Nederlands
Norsk
ਪੰਜਾਬੀ
Polski
Português
Română
Русский
Slovenščina
Shqip
Svenska
Kiswahili
தமிழ்
తెలుగు
ภาษาไทย
Türkçe
اردو
简体中文
flow
Gida
Batutuwa
Rukunoni
Hanyoyin koyo
Nema
Tambayoyi da amsoshin hira na SQL · Atisayen Hira na IT
Gida
/
Database
/
SQL
Database
SQL
Tambayar bayanan dangantaka: joins, indexes da transactions.
30
tambayoyi
ana sabuntawa kowane mako
Junior
10
Middle
12
Senior
8
SQL tambayoyi
15 / 30 ana nunawa
Tsoho
Shahararru
Sabbi
›
Bayyana INNER, LEFT, RIGHT da FULL JOIN.
Junior
#Join
#Query
Bayanai →
›
Gunnar da SELECT statement ke aiki?
Junior
#Query
Bayanai →
›
Yaya ake taɓa layuka tare da WHERE?
Junior
#Query
Bayanai →
›
Abubuwan haɗa-haɗa (COUNT, SUM, AVG, da sauransu) nini ne?
Junior
#Query
Bayanai →
›
GROUP BY da HAVING suna aiki ta yaya?
Junior
#Query
Bayanai →
›
ORDER BY da LIMIT suna aiki ta yaya, kuma ta yaya za ka iya magance shafuka?
Junior
#Query
Bayanai →
›
INSERT, UPDATE da DELETE suna aiki ta yaya?
Junior
#Query
Bayanai →
›
Yaya kuke jima da ɗin kayi tare da DISTINCT?
Junior
#Query
Bayanai →
›
Menene subqueries kuma kaida ne na amfani da su?
Middle
#Query
Bayanai →
›
UNION, INTERSECT da EXCEPT menene?
Middle
#Query
Bayanai →
›
CASE expression yadda ya aiki?
Middle
#Query
Bayanai →
›
Menene abubuwan aikin jiya da lokaci da aka fi amfani da su?
Middle
#Query
Bayanai →
›
Self-join nima ne?
Middle
#Query
Bayanai →
›
Window functions su nini?
Senior
#Query
Bayanai →
›
Menene Common Table Expressions (CTEs)?
Senior
#Query
Bayanai →
