Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

select only one row

Comment:

hello, i've got a select query which returns a couple of rows. now i would like for the query to return only one row (the first match it can find). how do i do that? thank you!

Reply:

try SELECT TOP 1 * FROM TABLE

0

Reply:

I've also seen the keyword "limit" used. The particular keyword and syntax will be particular to your database.

0

Reply:

Hi, You can limit the number of rows in the output of a query by using the rowcount parameter as sql > select * from emp where rowcount < 2; hope it will help u :-)

0

Update Listbox

MySQL Client GUI suggesti...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi all, I am using a sql compact database to update my records. I know the syntax to update one row and colums but is there a way/syntax to use the update keyword to update multiple rows and colums us...

Summary: Hi This is my script. SELECT T$ITEM, SUM(CASE WHEN T$YEAR=2005 THEN T$AUPP$1 ELSE 0 END) AS "2005 JAN", SUM(CASE WHEN T$YEAR=2005 THEN T$AUPP$2 ELSE 0 END) AS "2005 FEB", SUM(CASE WHEN T$YEAR=2005 THE...

Summary: The code that populates the ticket information into the next available row is Private Sub CommandButton1_Click() ActiveWorkbook.Sheets("Sheet1").Activate Range("A2").Select Do If ...