Database - How can we retrive first row in a table?

Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question

GeekInterview.com > Tech FAQs > Database

Go To First | Previous Question | Next Question

Database | Question 64 of 121

Print

How can we retrive first row in a table?

Total Answers and Comments: 5

Last Update: April 30, 2008 Asked by: sivagarlapati

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 23, 2007 08:44:22

#1

revathy

RE: How can we retrive first row in a table?

we can run a query like below :select first 1 * from <table name> It worked in informix..please check in other databases..

Is this answer useful? Yes | No

January 31, 2007 23:17:05

#2

rohini

RE: How can we retrive first row in a table?

select * from <table name> limit 1;

Is this answer useful? Yes | No

February 12, 2007 06:30:19

#3

Member Since: June 2006 Contribution: 48

RE: How can we retrive first row in a table?

SELECT * FROM EMPLOYEES WHERE ROWNUM=1;

Is this answer useful? Yes | No

February 12, 2007 06:30:36

#4

Member Since: June 2006 Contribution: 48

RE: How can we retrive first row in a table?

SELECT * FROM EMPLOYEES WHERE ROWNUM=1; IN ORACLE

Is this answer useful? Yes | No

April 30, 2008 07:26:57

#5

Member Since: April 2008 Contribution: 2

RE: How can we retrive first row in a table?

Select top1 * from<Table name> in SQL Server

Is this answer useful? Yes | No

Sponsored Links

About Us | Privacy Policy | Terms and Conditions | Contact | Site Map | Add Question | Propose Category | RSS Feeds | Articles Sitemap | Site Updates | Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved