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...

how will you retrieve first record in table

Answer Posted / saravana

select empname,empno from tablename order by empno fetch
first row only;

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2514


How to execute stored procedures?

1109


Mention the various locks that are available in db2.

1024


What is release/acquire in bind?

1091


Explain what are the various isolation levels possible?

1027


What os does db2 run on?

955


What is the role of data manager in the db2 database?

1091


what is the role of the cursor in db2?

1048


What is difference between rollback and commit?

1133


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9151


What is dclgen (declaration generator)?

1034


How to find the maximum value in a column in the db2 database?

1057


Define predicate?

1103


What is difference between alias and synonym in db2?

1118


List out the data types available.

1130