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:
Sh. Nazirov, A. Ne’matov, R. Qobulov, N. Mardonova. MA’LUMOTLAR BAZASI. 2007-y.
X. Zaynidinov, J. Usmonov, Sh. Redjepov, I. Yusupov. Ma’lumotlar bazasi. 2020-y.
https://www.w3schools.com/mysql/mysql_limit.asp
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
Do'stlaringiz bilan baham: |