Jump to content

sqlite select first row available


Recommended Posts

Hi which sqlite query is use to get first availble row

like im using

SELECT * FROM  mytable where ID = 1;
but in this query u have to tell id to pick row

how i can get first availble row ?

help !!!

Why don't you do SELECT TOP 1 * FROM mytable where ID = 1;?

Or just drop the WHERE altogether if that's what you're looking for. Hope this helps.

-- If the apocalypse comes... beep me.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...