Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Display n-1 rows from a table

This is a discussion on Display n-1 rows from a table within the SQL Server forums, part of the Databases category; How query and to display n-1 rows from a table. Kindly give me query and also the method dbtester...

Geeks Talk > Databases > SQL Server Display n-1 rows from a table

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   12-12-2006

dbtester Junior Member   Join Date: Oct 2006 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Display n-1 rows from a table How query and to display n-1 rows from a table. Kindly give me query and also the method dbtester

Sponsored Links

#2 (permalink)   12-12-2006

Jim.Anderson Expert Member   Join Date: Jun 2006 Posts: 140 Thanks: 2 Thanked 12 Times in 9 Posts

Re: Display n-1 rows from a table Quote: Originally Posted by dbtester How query and to display n-1 rows from a table. Kindly give me query and also the method dbtester Could you explain what exactly n-1 rows...

#3 (permalink)   12-20-2006

Innila Expert Member   Join Date: Sep 2006 Location: India Posts: 131 Thanks: 1 Thanked 20 Times in 20 Posts

Re: Display n-1 rows from a table Quote: Originally Posted by dbtester How query and to display n-1 rows from a table. Kindly give me query and also the method dbtester Need clarification reg ur question. Do u want to give the value 'n' in the where clause & retrieve n-1 rows?

#4 (permalink)   02-07-2008

sr_2407 Junior Member   Join Date: Feb 2008 Location: mumbai Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Display n-1 rows from a table my Query for this is as follows, select * from dept where rownum<=(select count(*)-1 from dept)

Geeks Talk > Databases > SQL Server

« Shared Memory Connection Read Write | Databases »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Inode Table	fred	Unix/Linux	2	10-22-2007 04:15 PM
don't use 100% for main table...	psuresh1982	HTML & CSS	3	05-17-2007 09:30 AM
Microsoft CRM : Display a SharePoint document library in a Microsoft Dynamics CRM 3.0 form	Jim.Anderson	Microsoft CRM	0	09-27-2006 07:39 AM
Need predefined Function or code for Data Display in PHP	norman	PHP	0	07-17-2006 05:17 PM
In one table...	Allan Paul	Oracle	4	06-20-2006 04:11 AM

All times are GMT -4. The time now is 05:27 AM.