Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Fetching selective records from SQL Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-13 : 09:00:49
Satheesh writes "Please suggest me a method for the following without using Stored Procedure:

1. To select a particular row from the Data base table while executing a query with some where condition. For example 34th row from the data fetched while executing the query with certain search criteria.

2. To select rows between a range while executing a query with some where condition. For example, rows between 5th and 10th from the data fetched while executing the query with certain search criteria.

We are struggling with this problem and please suggest us as early as possible.

Awaiting for your reply"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-03-13 : 09:00:49
This is reading much like a home work question. We've already answered the second one on the site. You should be able to search for it.
Go to Top of Page

joldham
Wiseass Yak Posting Master

300 Posts

Posted - 2002-03-13 : 09:29:21
graz,

Maybe you should make the "No Oracle, no Access, no ASP, no mySQL" bold on the Ask SQLTeam page and add in bold and caps "WE DO NOT DO YOUR HOMEWORK!"



Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-03-13 : 09:52:48
That's a great idea. I'll add that one to my to do list.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
   

- Advertisement -