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

i want to display 1 to 10 numbers using one select statement.

Answer Posted / nagesh

SELECT * FROM EMP WHERE ROWNUM<=10 ORDER BY ENO;

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql server and ase?

992


Explain ttitle and btitle.

1082


What is application trigger?

966


What does trigger mean in psychology?

929


How do I filter in sql profiler?

966


What does the acronym acid stand for in database management?

1003


What are data types in pl sql?

1097


What are the benefits of pl sql?

1079


How does one use sql*loader to load images, sound clips and documents? : aql loader

1144


How to check if a column is nullable before setting to nullable?

1077


What is composite data type in pl sql?

1055


How sql query is executed?

1089


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1045


Can a key be both primary and foreign?

960


What is user in sql?

988