|
|
|
||||||||
|
SQL needed for selecting only 10 records,Can anyone help me?
 There are lots of ways to select first desired record or row from a database table. Here are some example SQL statements That doesn't require additional application logic, but each database server requires different SQL syntax. SELECT ROWNUM,column1,column2,column3 FROM table_name WHERE ROWNUM |
||||
 |
||||
|
Unrated
2 ratings
|
 |
by
naeemsdk  06 Jul 2007 11:03 |
|
|
Comment
Comment
|
|||||||
|
|
|||||||
Well The ANSI standerd is after evreything else (SELECT nn FROM ... WHERE ... ORDER by ... LIMIT 0,10 then the ; at the end NB, LIMIT works like this LIMIT (From Record , for x records) Honest hurt my head thiniking from record x to y that's just WORNG but we all learn |
In SQL Server the simplest method is to use "SELECT TOP 10 * FROM MYTABLENAME". |
||||
|
||||
|
Unrated
2 ratings
|
|
by
Boris 25 Sep 2007 21:50 |
|
|
|
|
|
In sql table define some primary key as emp_code select * from tablename where emp_code between range1 and range2 |
||||
|
||||
|
Unrated
1 ratings
|
|
by
Gautam37 17 Nov 2007 09:28 |
|
|
|
|
|
Select * from fetch first 10 rows only. This is the query can be used when your database is DB2 . |
||||
|
||||
Unrated
0 ratings
|
|
by
kingo 17 Jan 2008 14:17 |
|
|
|
|
|
