Lower satrni kichik harfga o'zgartiradi upper


SQL Server / MS Access Syntax


Download 380.93 Kb.
bet3/3
Sana25.10.2023
Hajmi380.93 Kb.
#1719605
1   2   3
Bog'liq
Oxunjon Xatamov MB dan mustaqil ishi

SQL Server / MS Access Syntax:

  • SELECT TOP number|percent column_name(s) FROM table_name WHERE condition;

  • MySQL Syntax:

  • SELECT column_name(s) FROM table_name WHERE condition
    LIMIT number;

  • Oracle Syntax:

  • SELECT column_name(s) FROM table_name WHERE ROWNUM <= number;


    Xulosa
    Xulosa qilib aytganda, MySQL’da ma’lumotlar bilan ishlash uchun bir qancha standard funksiyalar mavjud bo’lib, ular ish jarayonida juda ko’plab qulayliklar tug’diradi.


    FOYDALANILGAN MANBALAR:

    1. Sh. Nazirov, A. Ne’matov, R. Qobulov, N. Mardonova. MA’LUMOTLAR BAZASI. 2007-y.

    2. X. Zaynidinov, J. Usmonov, Sh. Redjepov, I. Yusupov. Ma’lumotlar bazasi. 2020-y.

    3. https://www.w3schools.com/mysql/mysql_limit.asp

    4. https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html

    Download 380.93 Kb.

    Do'stlaringiz bilan baham:
  • 1   2   3




    Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
    ma'muriyatiga murojaat qiling