Template:Meta Data ref
From SQLZOO
Jump to navigation
Jump to search
Meta Data
What are my tables?
What are the columns of the BBC table?
Get the first 10 rows of the gisq.cia table.
Get the 11th to the 20th rows of the cia table - by population.
What version of the software am I using?
What is the syntax to view structure of table?
How can you determine the primary key using SQL?
Return a sequential record count for all records returned
DataWars:
Practice Data Science/Analysis with
+100 Real Life Projects
Navigation menu
Personal tools
Create account
Log in
Namespaces
Template
Discussion
English
expanded
collapsed
Views
Read
View source
View history
More
expanded
collapsed
Search
SELECT basics
quiz
SELECT from world
quiz
SELECT from nobel
quiz
SELECT in SELECT
quiz
SUM and COUNT
quiz
JOIN
quiz
More JOIN
quiz
Using NULL
quiz
Self JOIN
quiz
Reference
NoSQL zoo
SELECT
Functions
SELECT .. WHERE
SELECT .. GROUP BY
SELECT .. JOIN
SELECT .. SELECT
INSERT .. VALUES
INSERT .. SELECT
UPDATE
DELETE
CREATE TABLE
CREATE VIEW
CREATE INDEX
DROP
ALTER
UNION
LEFT JOIN
NULL
Tools
What links here
Related changes
Special pages
Printable version
Permanent link
Page information