Table limit

[Desaster]

Hi how I can get the first 10 rows of a table like in sql (order a limit) ?

[WASSIm.]

yes

[TAPL]

Try something like:

SELECT column_name FROM table_name LIMIT 10 

[Desaster]

I mean in a lua table (sql was just an expl)

[bandi94]

for i,v in pairs(table) do 
  
-- Your stuff 
  
if i == 10 then 
break 
end 
end 

[Desaster]

Thnx that's what I meant ^^

[Castillo]

If your table is indexed, then you can simply do this:

for index = 1, 10 do 
    local data = myTable [ index ] 
end 

[Sasu]

If your table is indexed, then you can simply do this:

for index = 1, 10 do 
    local data = myTable [ index ] 
end 

And if the index doesnt exist? To improve:

for index = 1, 10 do 
    local data = myTable [ index ] 
    if ( not data ) then break end 
end 

[Desaster]

my table is not indexed so the first sollution is the useful one anyways good to know this thnx all

[Renkon]

SELECT TOP 10 FROM TABLE WHERE ...