SQL interview question [closed]

As it currently stands, this question is not a good fit for our Q&A format. We e开发者_运维知识库xpect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 11 years ago.

I got following question on an interview:

Which SQL mechanisms allow user to browse tables sequentially?

---

Cursor is a good example - but I don't think you could really argue that Cursors are truely a part of SQL - rather they just tend to come bolted in with procedural languages used on database servers - like pl/SQL and T-SQL.

You could also make an argument for Recordsets, Dynasets, DataTables and DataViews, but those aren't part of SQL itself either.

They might be referring to ORDER BY with a sequential field on the table, but if so, they've not phrased their question very well...

Martin.

---

"CURSOR" might be the word that you should google for.