How to display First 4 rows From Database Table?

Question Posted / guest

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

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