Selecting specific Ron number - easy one sorry :(

[Autosys]

Hi there

A really easy one (probably) sorry but I was wondering if I had a table with 5 rows in it .. how can I select all the columns but only for a specific row?

FOR Example I need something like this.

select * from tablename where rownum = 10? Possible?

Thx
S

 

[ca8msm]

Yes, you can use a WHERE clause like you have done. How do you know which row you want though and what is the structure of your table?


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[Autosys]

The number of rows will be returned to me by a 3rd party and my query just needs to return all the columns for one specific row depending on what information they give me. The columns in the table will always be the same.

So for example. On a particular day they might pass me only the number 3. That's all I get from them (which will be row number 3 in this table)

I then need to pass this 3 to my query to select the colums for row number 3 in table x.

 

[SQLSister]

is this a number that is stored in your database or do you want the third row of the entire recordset? And what version of sql server are you using?

"NOTHING is more important in a database than integrity." ESquared

 

[bborissov]

NOBODY could be sure what is saved in ROW number 3 in SQL Server.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP

 

[ESquared]

There has to be an ORDER BY or "row #3" is meaningless.

Of all the people in the world, point to person #3 please?