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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-09 : 10:08:12
|
| Sarma challa writes "HI,I am selecting some data from oracle from 3 tables. Now the problem is I want the result must be between the values I pass to the query dynamically.some thing like this:select a.name,b.salary,c.dept from d_1 a,d_2 b,d_3 c where "some condition" and rownum between 10 and 20.But when I checked the technet,it is not possible,so i tried this,select * from (select a.name,b.salary,c.dept,rownum rnum from d_1 a,d_2 b,d_3 c where "some condition" ) where rownum between 10 and 20.But this one is giving me duplicate data. Pls help me in this regardThank you,Sarma" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-09 : 10:18:46
|
| This site is dedicated to Sql Server Questions. you can post that on a Oracle Discussion Forum.if by chance you chose to use Sqlserver . this Article by Graz should help you.http://www.sqlteam.com/item.asp?ItemID=566----------------------------Anything that Doesn't Kills you Makes you Stronger |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-01-09 : 13:36:40
|
If you're getting duplicate data, then it is probably because you have not specified enough information in your where clause to join your tables together. Typically this happens when you need more than one field to uniquely identify a row, but in your join syntax (which in Oracle resides in the WHERE clause) you don't use all of the identifying fields. (This happens in SQL Server too.  )You also might want to do a search in Google for Oracle Forums. There are a handful of them out there, but I can't testify to the helpfulness of any of them.  |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-01-09 : 13:43:16
|
quote:
You also might want to do a search in Google for Oracle Forums. There are a handful of them out there, but I can't testify to the helpfulness of any of them.
Certainly not as helpful as the SQLTeam posters!  Justin |
|
|
|
|
|
|
|
|
Need to restrict the search based on rownum