Interested to Buy Any Domain ? << Click Here >> for more details...
wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 29666 Views
- I also Faced
- E-Mail Answers
Answer Posted / tulasi ravi kumar
hi this is tulasi ravi
id - ravi106109@gmail.com
select * from emp where rowid in
(select rowid from emp
minus
select rowid from emp where rownum<=(
select count(*)-3 from emp))
feel free to mail queries,,,.....
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Where are sql server user names and passwords stored in sql server?
How to count duplicated values in a column in ms sql server?
Can we insert data if clustered index is disabled?
Explain candidate key, alternate key, and composite key?
Give the query of getting last two records from the table in SQL SERVER?
Can you force a query to use a specific index?
Explain what are the different index configurations a table can have?
What is a fill factor?
Describe the left outer join & right outer join. : sql server database administration
What are constraints?
What is instead of trigger sql server?
What are the results of running this script?
What are the parts of a function?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is a database in ms sql server?
