Sql query for top 5 records in oracle

select*from emp where rownum<=5;

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

1 comments:

laxminarayana said...

SELECT *
FROM (SELECT distinct * FROM emp ORDER BY RECORD desc)
WHERE ROWNUM < 5

Recent Posts