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 就可以了,