Anonymous

Not logged in

  • Log in
SQLZoo

Meta Data Reference

From SQLZoo

Namespaces

  • Page
  • Discussion

More

  • More

Page actions

  • Read
  • View source
  • History
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
Retrieved from "https://sqlzoo.net/w/index.php?title=Meta_Data_Reference&oldid=514"

Navigation

  • 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

Wiki tools

Wiki tools

  • Special pages

Page tools

Page tools

    User page tools

      More

      • What links here
      • Related changes
      • Printable version
      • Permanent link
      • Page information
      • Page logs
      • Powered by MediaWiki
      • This page was last modified on 10 July 2012, at 09:54.
      • Privacy policy
      • About SQLZoo
      • Disclaimers