Skip to content
Course Notes: Introduction to SQL Server
First lesson in SQL Server (SELECtion BOX)
We can use SELECT TOP (50) PERCENT * FROM database_name
but it's not working at postgreSQL because the course is with MSSQL do not forget to check syntax of MySQL & PostgreSQL.
DataFrameas
df1
variable
-- Or you can select by row or two ...etc!
SELECT
world.countries.code,
world.countries.name,
world.countries.capital
FROM
world.countriesDataFrameas
df
variable
-- Select the table
SELECT
*
FROM books