Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL interview question [closed]

Tags:

sql

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

like image 328
Tomek Tarczynski Avatar asked Jul 08 '10 08:07

Tomek Tarczynski


1 Answers

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.

like image 106
Martin Milan Avatar answered Nov 09 '22 01:11

Martin Milan