1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / lmeher.tcs

Answers were Sorted based on User's Feedback



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

Answer / hussain

select * from emp minus select * from emp where rownum<=
(select count(*)-10 from emp);

Is This Answer Correct ?    0 Yes 3 No

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

Answer / v.siva ramudu

SELECT CNUM,FNAME, DEPTNO
FROM COMPANY
WHERE CNUM <= 10;

Is This Answer Correct ?    3 Yes 12 No

Post New Answer

More SQL PLSQL Interview Questions

what is “go” in t-sql? : Transact sql

0 Answers  

what is outer join? what is selef join? what is difference between them? what is cartecion join?

1 Answers   Fiserv, Herbinger, Synechron,

What is the difference between inner join and left join?

0 Answers  

What is sqlite used for?

0 Answers  

How we can update the view?

0 Answers  




what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

Mention what is the use of function "module procedure" in pl/sql?

0 Answers  

what is the different between unique+not null & primary key,

4 Answers  

What is query optimization in sql?

0 Answers  

What is trigger in pl sql?

0 Answers  

How many sql statements are used?

0 Answers  

What is a ddl command?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories