A harfidan boshlanadigan ismlar

Beginner 50 ball SQL 1000 ms admin

Ismi A harfi bilan boshlanadigan talabalarning to‘liq ismini (name) chiqaring.

Maslahat: LIKE va % belgisi.

Namunaviy ma‘lumotlar

students· 10 qator

id integer	name text	group_name text	city text	birth_year integer	score integer
1	Otabek Qodirov	IT-21	Andijon	2001	70
2	Aziz Nazarov	MT-21	Andijon	2001	71
3	Elyor Karimov	IT-22	Toshkent	2006	43
4	Kamola Mirzayev	IT-22	Samarqand	2001	86
5	Elyor Yusupov	MT-21	Toshkent	2005	50
6	Umida Xolmatov	IT-22	Buxoro	2007	100
7	Sardor Xolmatov	MT-21	Samarqand	2002	73
8	Temur Ergashev	IT-22	Andijon	2006	85
9	Kamola Nazarov	IT-22	Buxoro	2004	40
10	Akmal Aliyev	MT-21	Andijon	2001	56

Jadval tuzilishi (CREATE TABLE)

CREATE TABLE students (id INTEGER PRIMARY KEY, name TEXT, group_name TEXT, city TEXT, birth_year INTEGER, score INTEGER);

Bitta ustun: name.

Aziz Nazarov

Akmal Aliyev

Qatorlar tartibi ahamiyatsiz, ustunlar tartibi muhim. Yechim yashirin, kattaroq ma‘lumotlarda ham tekshiriladi.

Ranglar Shrift O‘lcham 14px

Chekinishbo‘sh joy soni

2 4

Uzun qatorlarni o‘rash Vim rejimi Til shabloniMuharrir bo‘sh bo‘lsa qo‘yiladi

Kodingiz shu brauzerda saqlanadi.

Kirish