+ 1

Is there a alternative for TOP in sql

I have a sql query that uses TOP. "SELECT TOP 1 Id FROM Results where colum2=0" Every now and then the querry gives undefined results. Is there another way to get the first row in the table that meets the requirements ? Could the query be optimized ? I use sql.

30th Aug 2021, 12:09 PM
sneeze
sneeze - avatar
3 odpowiedzi
+ 2
Yes, I use MSSQL. I get null back from the query. command = new SqlCommand(SqlStr, conn); reader = command.ExecuteReader(); try { while (reader.Read()) { if (!reader.IsDBNull(0)) { ........
30th Aug 2021, 12:25 PM
sneeze
sneeze - avatar
+ 2
Sneeze, Does it work correctly if you remove the NULL check condition? I've forgotten how, but did you check whether there was any record matching the query condition? I just thought about what happens when no match was found ...
30th Aug 2021, 1:39 PM
Ipang
+ 1
Hi Sneeze, Can you elaborate further on that "gives undefined results" part? how it worked? You are using MSSQL right? cause as I remember TOP is used by MSSQL only ...
30th Aug 2021, 12:15 PM
Ipang