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 to display First 4 rows From Database Table?

Answers were Sorted based on User's Feedback



How to display First 4 rows From Database Table?..

Answer / rathi.sql

select * from employees
where rownum<=4

Is This Answer Correct ?    24 Yes 3 No

How to display First 4 rows From Database Table?..

Answer / rathi.sql

select * from employees
where rownum<=4

Is This Answer Correct ?    16 Yes 2 No

How to display First 4 rows From Database Table?..

Answer / b v n kiran kumar

SELECT * FROM EMP
WHERE ROWNUM<=4;

Is This Answer Correct ?    3 Yes 2 No

How to display First 4 rows From Database Table?..

Answer / shilpa

select top 4 * from table for sql server

Is This Answer Correct ?    0 Yes 0 No

How to display First 4 rows From Database Table?..

Answer / testing

you can get the first four rows using this query

select * from emp limit 4

Is This Answer Correct ?    2 Yes 5 No

How to display First 4 rows From Database Table?..

Answer / naina singh

select top 4 * from table

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More Oracle General Interview Questions

can we pass two out parameters at a time in function?please answer to my question

3 Answers   Wipro,


What is not equal to in oracle?

0 Answers  


What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

1 Answers  


How to commit the current transaction in oracle?

0 Answers  


Explain table?

0 Answers  


How to assign values to data fields in record variables?

0 Answers  


i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?

5 Answers   Oracle,


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

0 Answers  


How to delete a column in an existing table?

0 Answers  


write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,


how to join query for one source type is oracle another source type is sql server ?

0 Answers   iGate,


What different of iner joint & outer joint with example

4 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)