Skip to Content
0
Former Member
Oct 29, 2004 at 04:12 PM

Select Single and Select up to 1 rows

220 Views

Hi,

I have a scenario in which queries one using Select single and the other using Select up to 1 rows on the same table with the same where clause returns different data.

Also Select up to n rows (Where n = say 10 ) behaves differently at different times.

Can anyone tell me how select single is different from select up to 1 rows and why does select up to n rows behave differently at different times ?

Thanks

Rajesh