Scribd
Upload
6 views2 pages

SQL Basics: Queries and Keywords

SQL allows querying databases to select and retrieve data. Keywords like SELECT, FROM, and WHERE are used to query for specific fields, tables, and filter results. Wildcard characters can be used to match parts of text values.

Uploaded by

Jerry Chable
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views2 pages

SQL Basics: Queries and Keywords

SQL allows querying databases to select and retrieve data. Keywords like SELECT, FROM, and WHERE are used to query for specific fields, tables, and filter results. Wildcard characters can be used to match parts of text values.

Uploaded by

Jerry Chable
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SQL

(Structured Query Language)


SQL(Structured Query Language) Allows us to ask questions in a database and get results
(data).
Question- query

Key words:
Select

*  wildcard
From  location

Select * from “result”;


Select “AthleteID”,”Rank” from “result”;
Select “AthleteID”,”Rank” from “result” where “Rank” = 1;

names with B * or % beside B works


Text only has single quotes. Numbers don’t take quotes

You might also like