Solved

set rowcount using subquerys

Posted on 2004-04-20
2
4,147 Views
Last Modified: 2012-06-21
I have a subquery under sybase included into a select statement, an example..

select name from (select * from table1, table2, where...)

I know that using "set rowcount" I can limit rows from the main select statement, but I want to restrict rows in the inner select statement,

This is a result of migrating from sql server 2000 to sybase, please help me before I get completely crazy.
0
Comment
Question by:fgm0
2 Comments
 
LVL 15

Accepted Solution

by:
namasi_navaretnam earned 500 total points
ID: 10880628
Try something like this: Sybase does not support TOP keyword.

Set Rowcount 100

select *
into #temp
from table1, table2, where...

select name from #temp

regards-
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Query 2 336
SyBaseSQL Select column if it exists 3 1,419
InterSystems Caché OPEN QUERY 4 485
How to get military time in Sybase? 3 90
Knowing where your website is hosted is as important as the features you receive, the monthly fee, and the support you receive. Due diligence should be done when choosing your next hosting provider.
As a business owner, there are many things that keep you up at night. Profit margins, employee retention, human resource protocols, whether your product or service will remain competitive. When you own or manage a technology company that operates la…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question