php.mssql2008,读数据库

Question

<?php
$db =new PDO("sqlsrv:Server=.,1433;Database=test","sa","123456");
$sql = "SELECT * FROM name";



$res = $db->query($sql);


while($row = $res->fetch()){


  echo $row['id'] . "," . $row['name'];
  echo "<br />";
  }

请问，我想读取前面3行数据怎么做？谢谢各位！

Answer 1

直接用select * from name limit 3 就可以了,