select * from last10 minus select * from last10 where row >= (select

Write a query to get last 10 records from the table.

Question Posted / akshaya

12 Answers
26268 Views
iNautix, I also Faced
E-Mail Answers

Answer Posted / akshaya

select * from last10
minus
select * from last10
where row >= (select COUNT(*)-10 from last10)

condition should be >= not <=
for all the above queries

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference between inner and outer join? Explain with example. : Sql dba

973

Explain the uses of control file.

994

what are the different index configurations a table can have? : Sql dba

939

What is nvarchar in sql?

887

Is postgresql a nosql database?

1079

What pl/sql package consists of?

1033

Explain how to use transactions efficiently : transact sql

926

What is full join?

899

What are the different types of triggers?

1056

what is a control file ? : Sql dba

991

Explain what is a subquery ?

1125

Can you sum a count in sql?

956

What does where 1 1 mean in sql?

981

Why are aggregate functions called so?

897

Can you selectively load only those records that you need? : aql loader

986