SQL Computer Programming for Beginners: The Ultimate Guide To Learn SQL Programming Basics, SQL Languages, Queries and Practice Problems, SQL Server and Database, Coding Languages for Beginners by Hack Anthony

Author:Hack, Anthony [Hack, Anthony]
Language: eng
Format: epub
Published: 2019-12-03T16:00:00+00:00

INSERT INTO Patient_Examination

VALUES (1,3, 'Positive'),

(1,3, 'Negative'),

(2,5, 'Positive'),

(1,4, 'Negative'),

(8,1, 'Positive'),

(5,2, 'Negative'),

(9,3, 'Positive')

Selecting Data

We have inserted data in all of our tables. Now is the time to retrieve that data. To do in SQL, we use SELECT query. You can either select data from all the columns or data from individual columns. The syntax for both operations is as follows:

Selecting all columns

SELECT * FROM Table_Name

Selecting Individual Columns

SELECT column1, column2, column3 ... columnN FROM Table_Name

Let’s select all the records from the Patients table. Execute following query:

SELECT * FROM Patients

This query will retrieve all records with all column values from Patients table. The result of the above query will look like this:

id

name

age

gender

blood_group

phone

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.