skip to main | skip to sidebar

Sql Queries in Oracle and SQL Server

SQLQueriesCollection is blog for all sql queries in SqlServer at one place.SQL,SQL Query,SQL Queries,SQL Query Code,SQL Query Example,SQL Query Syntax,Basic Sql Queries,Query,SQL Examples,SQL Basic Queries,Structured Query Language,sql oracle queries,oracle sql queries,sql queries in oracle,sql-oracle,oracle sql.oracle basics,sql basics,oracle sql examples,sql orqcle examples

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
Related Posts : sql query for top 5 records, top 5 records in oracle
Posted by sqlqueries
Labels: sql query for top 5 records, top 5 records in oracle

1 comment:

laxminarayana said...

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

November 17, 2008 at 12:12 AM

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Recent Posts

Loading...

  • Movies Songs
  • BeautifulPictures
  • Sql Server Faqs
  • Software Testing
  • CheckVocabulary

Enter your email address:

Delivered by FeedBurner

Blog Archive

  • ►  2013 (1)
    • ►  February (1)
  • ►  2012 (8)
    • ►  November (8)
  • ►  2009 (10)
    • ►  June (1)
    • ►  May (1)
    • ►  April (4)
    • ►  February (2)
    • ►  January (2)
  • ▼  2008 (20)
    • ►  December (4)
    • ►  November (1)
    • ▼  April (2)
      • sql query for second highest salary in oracle
      • Sql query for top 5 records in oracle
    • ►  March (8)
    • ►  January (5)