Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get last 10 records from the table.
- 12 Answers
- 26679 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / hussain
select * from emp minus select * from emp where rownum<=
(select count(*)-10 from emp);
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is union and union all keyword in sql and what are their differences?
What is the process of copying data from table a to table b?
what happens if null values are involved in expressions? : Sql dba
What are stored procedures in mysql?
How many sql commands are there?
What is rowid in sql?
What is sql not null constraint?
Is join and inner join the same?
How do you clear the screen in sql?
how to fetch alternate records from a table? : Sql dba
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
what is online transaction processing (oltp)? : Sql dba
what are numeric data types? : Sql dba
What type of join is sql join?
what is clause? : Sql dba
