Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



if there is a table with huge number of records and if i want to extract only first 3 records from..

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

if there is a table with huge number of records and if i want to extract only first 3 records from..

Answer / gummadi

select * from table_name
order by ascending
fetch first 3 rows only

Is This Answer Correct ?    3 Yes 0 No

if there is a table with huge number of records and if i want to extract only first 3 records from..

Answer / hemachandar

select * from table_name
fetch first 3 rows only;

Is This Answer Correct ?    2 Yes 0 No

if there is a table with huge number of records and if i want to extract only first 3 records from..

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

Post New Answer

More DB2 Interview Questions

Once you create a view, where would information about the view be stored?

1 Answers  


Which component is responsible for processing sql statements and selecting access paths?

0 Answers  


Explain package in db2 and its advantages?

0 Answers  


List out the data types available.

0 Answers  


db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  


How do you retrieve the data from a nullable column?

2 Answers  


How many sub queries can you combine together ?

4 Answers   IBM,


How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,


Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,


Is db2 a mainframe database?

0 Answers  


Which catalog table stores referential constraints?

1 Answers  


What is the difference between CS and RR isolation levels?

1 Answers  


Categories