Welcome aboard! We are happy you are here and wish you good net-raft!
in mysql: 
SELECT *
FROM credits
LIMIT 5; // top 5 
in oracle: 
SELECT *
FROM credits
WHERE ROWNUM <=5; 
The most helpful SQL solutions
how to execute select into using sql ?SQL
Click to see more ...
769
53
convert string to date sqlSQL
Click to see more ...
665
42
How to get the last record from table using sql ?SQL
Click to see more ...
579
33
create table sqlSQL
Click to see more ...
355
23
How use like using sql ?SQL
Click to see more ...
442
22
How to get the last 10 records using mysql ?SQL
Click to see more ...
332
21
rows to columns sqlSQL
Click to see more ...
284
17
insert new column into table sqlSQL
Click to see more ...
287
16
How to convert the values to lowercase using sql ?SQL
Click to see more ...
307
13
How to change a negative number to positive using sql ?SQL
Click to see more ...
239
11