first row of a table

Wrox Programmer Forums

		Wrox Programmer Forums > Database > SQL Language
first row of a table

SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

January 11th, 2005, 09:04 AM

Adam H-W

Adam H-W is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 347

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via MSN to Adam H-W

Default

first row of a table

Hi there

How do I select the first row that appears in a table without referring to the data in it. Even if the top row of data is deleted, I want to be able to automatically display the second etc etc

thanks

Adam

Old

January 11th, 2005, 09:07 AM

Jonax

Jonax is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 184

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via MSN to Jonax

Default

SELECT TOP 1 * FROM tbTableName ORDER BY SomeField

Old

January 11th, 2005, 10:15 AM

Adam H-W

Adam H-W is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 347

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via MSN to Adam H-W

Default

cool, thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Row Count in each table	ayazhoda	Access VBA	0	April 15th, 2008 04:31 PM
UPDATING 1 row with another row in same table	rit01	SQL Server 2000	3	February 19th, 2006 08:55 AM
How to duplicate 1 row in table	minhpx	SQL Language	1	December 20th, 2004 09:51 AM
i need to lock a row in table	alyeng2000	SQL Server 2000	6	May 17th, 2004 09:21 AM