| Author: Syed Shakeer Hussain 21 Dec 2009 | Member Level: Bronze | Rating:  Points: 1 |
Hi.... Select top 10 column-name from table order by column-name
|
| Author: Anoop 22 Dec 2009 | Member Level: Bronze | Rating: Points: 1 |
hi, check this
select top 10 * from <TableName> Order by <ColumnName> ASC
|
| Author: chaitanya 06 Aug 2010 | Member Level: Bronze | Rating: Points: 0 |
select * from tablename where rownum <11;
|
| Author: chaitanya 22 Oct 2010 | Member Level: Bronze | Rating: Points: 1 |
Hi...
sSQL="SELECT TOP 10 ID, FName, LName FROM EmployTable"
|
| Author: Shivprasad H 21 Jul 2012 | Member Level: Bronze | Rating: Points: 0 |
Select * from tab1 order by id desc limit 10
|
| Author: Shivprasad H 21 Jul 2012 | Member Level: Bronze | Rating: Points: 0 |
Select * from tab1 order by id desc limit 10
|