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

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

1067


please send me forms, xml pulisher questions,answers

2066


q)what are the validations in sql*loader

2331


tell me the scenarios of the independent in reports

2564


what is global tempory table?

7126


What does appl_top directory contain?

1078


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.

2974


please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3572


What are the Standard Reports and Forms in HRMS?

2228


Do you know where we can check the status of po?

1189


What is sca and how is it useful?

1049


What is the concept of soa governance?

1217


tell me the scenarios of the independent in reports

2435


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2168


How can you achieve loose coupling in soa framework?

1175