if there is a table with huge number of records and if i
want to extract only first 3 records from the table, what
query i have to provide to retreive first 3 records
Answers were Sorted based on User's Feedback
Answer / andank
SELECT * FROM <qualifier>.<table_name>
FETCH FIRST 3 ROWS ONLY
WITH UR;
The above query holds good, if you are thinking to fetch
rows in any specific order. Otherwise make use of "ORDER
BY".
If you want to filter the records bases on some condition
and fetch first 3 rows, make use of WHERE clause. For
example, if you want to see first 3 records of ACCOUNTS
department, use WHERE DEPTID ='Accounts' FETCH FIRST 3 ROWS
ONLY
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / hemachandar
select * from table_name
fetch first 3 rows only;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / viji
If there is any specific order they have to be fetched then use fetch first 3 records only.
Without order by, fetch first 3 records only will retrieve any 3 records in random order.
Is This Answer Correct ? | 0 Yes | 0 No |
What is a thread?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
When do you use the IMAGECOPY?
what is a collection?
What is the purpose of the QUIESE Utility?
What is -904 sql code? How to resolve it?
Name the different types of Table spaces.
is it possible to get -811 error when you use cursors. why?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What do you mean by NOT NULL? When will you use it?
What is a DBRM, PLAN ?