Wednesday, April 1, 2020

RedShift Database AWS

Query used to describe table table_name
  • SELECT * FROM pg_table_def WHERE tablename = 'table_name'

Query to get top 10 record
  • select top 10 * from table_name

No comments:

Post a Comment