Answer Posted / suresh babu
SELECT * FROM t1 a
WHERE 5 = (SELECT COUNT(rowid)
FROM t1 b
WHERE a.rowid >= b.rowid);
This Query,Which is used to find 5 record from Table.
Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
what is meant by urlencode and urldocode? : Sql dba
How many types of relationship are there?
What are transaction and its controls?
Is it possible to pass parameters to triggers?
Why procedure is used in sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
How can you save or place your msg in a table?
what are different types of collation sensitivity? : Sql dba
Explain lock escalation? : Transact sql
how is exception handling handled in mysql? : Sql dba
What is a crud api?
How to run sql functions in pl/sql?
Where is all the data on the internet stored?
what are string data types? : Sql dba
Can we create foreign key without primary key?