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 ...
765
53
convert string to date sqlSQL
Click to see more ...
660
42
How to get the last record from table using sql ?SQL
Click to see more ...
572
33
create table sqlSQL
Click to see more ...
350
23
How use like using sql ?SQL
Click to see more ...
436
22
How to get the last 10 records using mysql ?SQL
Click to see more ...
327
21
rows to columns sqlSQL
Click to see more ...
280
17
insert new column into table sqlSQL
Click to see more ...
282
16
How to convert the values to lowercase using sql ?SQL
Click to see more ...
301
13
How to change a negative number to positive using sql ?SQL
Click to see more ...
235
11