تبلیغات
SQL - مثال

مثال

نویسنده :tamishan tamishan1
تاریخ:سه شنبه 23 آبان 1391-12:54 ق.ظ

مثال : Query بنویسید که انهایی را نشان بده که FirstName   انها 4  حرفی باشد.

 

 

 

 

SELECT

                          *

FROM

               Student

WHERE

       FirstName     like  ' ____ '

City ID

Last Name

First Name

Age

ID

30

Panahi

Sara

36

3

40

Salimi

Mona

15

4

 

 

 

مثال : انهایی را نشان بده که حداقل اسمشان 2 حرفی وحرف اول اسمشان  S باشد.

SELECT

                          *

FROM

               Student

WHERE

       FirstName     like  ' S_%'

 

City ID

Last Name

First Name

Age

ID

20

Baghery

Samira

54

2

30

Panahi

Sara

36

3

 




داغ کن - کلوب دات کام
نظرات() 
http://kamifrancher.hatenablog.com
سه شنبه 24 مرداد 1396 11:39 ق.ظ
Howdy! Do you know if they make any plugins to safeguard against hackers?
I'm kinda paranoid about losing everything I've worked hard on. Any
recommendations?
How much can you grow from stretching?
یکشنبه 15 مرداد 1396 10:48 ب.ظ
Thank you for sharing your info. I truly appreciate your efforts and I am waiting for your further post thank you once again.
manicure
دوشنبه 4 اردیبهشت 1396 05:35 ق.ظ
After going over a few of the blog posts on your blog, I truly appreciate your technique of blogging.
I saved it to my bookmark site list and will be checking back in the near
future. Take a look at my web site too and let me know what you
think.
manicure
یکشنبه 20 فروردین 1396 02:11 ب.ظ
There's definately a lot to learn about this issue. I love all the points you have made.
الهام
شنبه 27 آبان 1391 01:59 ب.ظ
بسیار عالی
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo