How to display First 4 rows From Database Table?

Answer Posted / testing

you can get the first four rows using this query

select * from emp limit 4

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to connect to oracle using service name instead of sid?

764


How to insert a new row into a table in oracle?

807


Which is faster join or subquery in oracle?

715


What is a lookup table in oracle?

725


What is tns service name?

813


how to make an oracle object

2070


What is analyze command used for?

782


How to load excel data sheet to oracle database

748


Design database draw er diagram for a certain scenario ?

4307


What is integrity and what is constraint??Explain with example

1942


How to establish administrator authentication to the server?

757


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2180


What is system tablespace?

826


How to resolve the ORA-39133 error in Oracle?

786


Differentiate between post-database commit and post-form commit?

761