SQL interview question

Question

I got following question on an interview:
Which SQL mechanisms allow user to browse tables sequentially?

Answer 1

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

Answer 2

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.

Answer 3

We can use Cursors or While statement to achieve this:

Here is the example.. http://www.prepare4interview.com/1698/which-sql-mechanisms-allow-user-browse-tables-sequentially