LEFT -funktsiyasi asl satrning boshlang‘ich satrini qaytaradi. RIGHT

Download 1.63 Mb.
bet	8/9
Sana	19.11.2023
Hajmi	1.63 Mb.
	#101516

1 2 3 4 5 6 7 8 9

Bog'liq
database
Rux

LEFT -funktsiyasi asl satrning boshlang‘ich satrini qaytaradi.
RIGHT- funktsiyasi belgilangan sondan tashkil topgan pastki qatorni qaytaradi.
Ishni bajarish tartibi
Korpus nomli jadvalga yuqorida ko‘rsatilgan buyruqlarini tadbiq qiling.

So‘rov: Select * from auth_user1;

Natija:

2. So`rov: Select LOWER(username) from auth_users2;
Natija:

3. So`rov: Select UPPER(username) from auth_users2;
Natija:

5. Lpad ('', , '').
So`rov: SELECT LPAD(username, 5,mayda) AS newarea
FROM auth_users1;
Natija:

6. Rpad ('', , '').
So`rov: SELECT RPAD(username, 3, 'may') AS qisqartirma
FROM auth_users1;
Natija:

7. Length (''), octet_length ('')
So`rov: select Length(username) from auth_users2;
Natija:

8. LTRIM, RTRIM - Satrning chap va ong tomonidagi probellarni olish.

So`rov: SELECT id, username, LTRIM(username) AS left_trimmed_username, RTRIM(username) AS right_trimmed_username
FROM auth_users1;
Natija:

9. LEFT(qator,miqdor) – qatorning chap tomonidan, ko‘rsatilgan miqdordagi belgilarni qaytaradi.
So`rov: Select Left(username,5) as username from auth_users1;
Natija:

10. RIGHT(qator, miqdor) - qatorning o’ng tomonidan, ko‘rsatilgan miqdordagi belgilarni qaytaradi;

Download 1.63 Mb.

1 2 3 4 5 6 7 8 9

Download 1.63 Mb.