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

What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Answer Posted / apps

ROWNUM is generally used in >=, <=, <, >. But there is
exception, you can use it = also but only with 1 as
ROWNUM=1, it will display first record in table. If you use
ROWNUM=10…. Or any number other than 1 then it will not
display any records.

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2674


What do you understand by a set of books?

1155


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

3082


How to move the one file from one instance to another instance? And your scripts also?

1176


Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

1112


How can we import the data into a database using sql * loader?

1245


tell my any difficult situtation you solved in your experience in your company?

2364


What is oracle soa suite?

1303


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2163


Can u give the Documentation of Custom.pll in oracle apps

3523


What are do's and dont's of Interface?

2481


What are file in oracle.

2289


How many schemas we have? how many you have used?

2114


what are the prerequisites for costing transactions?

3190


Do you know what is applysys in oracle application database schema, what is apps?

1227