Ad
ana-codevs.Javatlacati

Where Am I?

you can detail the names of the columns

Code
Diff
  • SELECT current_database FROM current_catalog
    • SELECT * FROM current_catalog
    • SELECT current_database FROM current_catalog
ana-codevs.ana-code

Basic Select (SQL)

offset => identifies the line where to beging obtaining the records

Code
Diff
  • SELECT name
FROM greetings
LIMIT 10 offset 0;
    • SELECT name
    • FROM greetings
    • LIMIT 10
    • LIMIT 10 offset 0;
ana-codevs.markfabs

Basic Select (SQL)

Code
Diff
  • SELECT name
FROM greetings
LIMIT 10
    • SELECT g.name
    • FROM greetings g
    • LIMIT 10;
    • SELECT name
    • FROM greetings
    • LIMIT 10