Clauses Of SQL Lesson 02

1.5.14
01.Select

This is to specify  the columns needed  for  Output.

The column names that follow the select keyword determine which columns will be returned in the results. You can select as many column names that you'd like, or you can use a "*" to select all columns.


example-(a) select Sname , Marks
            (b) select *

02.From

specifies the table that will be queried to retrieve the desired results.

example-(a) from Student
            (b) From EMP

03.Where

Specifies the Conditional creative a that applies to data.

example-(a) where marks>=50
            (b) where SName='Jone'


Conditional selections used in the where clause:

=Equal
>Greater than
<Less than
>=Greater than or equal
<=Less than or equal
<>Not equal to
Labels:
  1. Fanz

    thank you! continue

  2. thanks for your informative post. buy facebook likes

  3. Anonymous

    of the many blogs I visit this blog recently that I think is interesting and good at reading the article jaket kulit sukaregang thanks admin visit back

  4. Your blog has brought me great experience. I regularly to your blog, and learn many new things. Thank you for sharing with us. I also want to invite you to visit our webstie and give us advice. We provide solutions to prevent insects from entering the home. Protect your family's health. We manufacture and installation of mosquito nets doors (luoi chong muoi , cửa lưới chống muỗi tại Hà Nội), UPVC doors (giá lưới chống côn trùng inox), the self-rolling mosquito net door (cửa lưới chống muỗi tự cuốn), mosquito nets stainless steel (lưới chống côn  trùng inox 304). If you would like to install anti-mosquito screen door (cửa lưới chống muỗi giá rẻ nhất), please contact us. Thank you very much!

  5. Thank you for sharing with us. I would love your opinion. We hope that you will continue to have new perspectives in the future. If you are interested in installing doors mosquito nets ( cửa lưới chống muỗi ), insect repellent to protect the health of the family, please contact us. We will gladly assist you at any time.

Post a Comment