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

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 the difference between sql and t-sql? : Transact sql

0 Answers  


How much does a sql dba make? : SQL DBA

0 Answers  


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,


What are the query optimization techniques?

0 Answers  


what is the difference between truncate and delete statement? : Transact sql

0 Answers  






What are pl/sql cursors?

0 Answers  


difference between cursor and procedure in a package

3 Answers   PCS,


What is an implicit commit?

0 Answers  


How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers   Pitney Bowes,


What found sql?

0 Answers  


what is the difference between implicit conversions and explicit conversions?

2 Answers  


What is difference between sql and oracle?

0 Answers  


Categories