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
How many postgresql users are there, worldwide?
What is a behavioral trigger?
What is varchar example?
How do I save a stored procedure?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Are null values same as that of zero or a blank space?
What are different functions in sql?
what is the bond code in materialized view?
What is left join example?
What language is oracle sql developer?
what is not null constraint? : Sql dba
What is data definition language?
What are the three pl sql block types?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Is it possible to link two groups inside a cross products after the cross products group has been created?