Write a query to get last 10 records from the table.
Answers were Sorted based on User's Feedback
Answer / hussain
select * from emp minus select * from emp where rownum<=
(select count(*)-10 from emp);
Is This Answer Correct ? | 0 Yes | 3 No |
SELECT CNUM,FNAME, DEPTNO
FROM COMPANY
WHERE CNUM <= 10;
Is This Answer Correct ? | 3 Yes | 12 No |
what is the difference between sql and t-sql? : Transact sql
How much does a sql dba make? : SQL DBA
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..
What are the query optimization techniques?
what is the difference between truncate and delete statement? : Transact sql
What are pl/sql cursors?
difference between cursor and procedure in a package
What is an implicit commit?
How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?
What found sql?
what is the difference between implicit conversions and explicit conversions?
What is difference between sql and oracle?