#Query

28 tambayoyi

Bayyana INNER, LEFT, RIGHT da FULL JOIN.SQL#joinJunior
Gunnar da SELECT statement ke aiki?SQL#queryJunior
Yaya ake taɓa layuka tare da WHERE?SQL#queryJunior
Abubuwan haɗa-haɗa (COUNT, SUM, AVG, da sauransu) nini ne?SQL#queryJunior
GROUP BY da HAVING suna aiki ta yaya?SQL#queryJunior
ORDER BY da LIMIT suna aiki ta yaya, kuma ta yaya za ka iya magance shafuka?SQL#queryJunior
INSERT, UPDATE da DELETE suna aiki ta yaya?SQL#queryJunior
Yaya kuke jima da ɗin kayi tare da DISTINCT?SQL#queryJunior
Menene subqueries kuma kaida ne na amfani da su?SQL#queryMiddle
UNION, INTERSECT da EXCEPT menene?SQL#queryMiddle
CASE expression yadda ya aiki?SQL#queryMiddle
Menene abubuwan aikin jiya da lokaci da aka fi amfani da su?SQL#queryMiddle
Self-join nima ne?SQL#queryMiddle
Window functions su nini?SQL#querySenior
Menene Common Table Expressions (CTEs)?SQL#querySenior
Menene UPSERT (INSERT ON CONFLICT)?PostgreSQL#queryJunior
RETURNING clause yana aiki menene?PostgreSQL#queryJunior
CTEs da recursive queries na PostgreSQL suna aiki ta yaya?PostgreSQL#queryMiddle
Kewan yadda CRUD operations ke aiki a MongoDB?MongoDB#queryJunior
Waɗannan jinjinay da MongoDB ke ba da su?MongoDB#queryJunior
How do find queries and projections work?MongoDB#queryJunior
Yaaya ake saka, sabunta da share jigogi?MongoDB#queryJunior
Pagidemawa da pagination suna aiki ta yaya a MongoDB?MongoDB#queryJunior
Yadda za ka haɗu da yanayin sha'adi da ma'auni na tunani?MongoDB#queryJunior
Aggregation pipeline nima ne?MongoDB#queryMiddle
Waɗanne jujjuyawa jujjuye da MongoDB ke ba da?MongoDB#queryMiddle
Waƙaƙen sanin aggregation da MongoDB ta bayar?MongoDB#querySenior
Geospatial queries suna aiki ta yaya a MongoDB?MongoDB#queryMiddle