Suppose we have a table with the values

WayPointsID Latitude Longitude PhoneNumber
1 -34.668516349643596 150.81978125 9886558702
2 -35.09660198927241 150.457232421875 9886558702
3 -34.713682925540354 149.74312109375 9886558702
4 -34.27452911659509 149.6167783203125 9886558702
5 -33.56343076390862 150.2869443359375 9886558702

What will be the output of the below?

SELECT *
FROM [dbo].[tblWayPoints]
WHERE [WayPointsID] = CAST(RAND()*5 AS INT)

 Posted by Rajnilari2015 on 1/24/2016 | Category: Sql Server Interview questions | Views: 1163 | Points: 40
Select from following answers:
  1. Pickup the WayPointsId randomly between 1 to 5
  2. Pickup the WayPointsId randomly between 0 to 5
  3. Pickup the WayPointsId sequentially between 1 to 5
  4. Pickup the WayPointsId sequentially between 0 to 5
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response