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
- 29850 Views
- I also Faced
- E-Mail Answers
Answer Posted / tulasi ravi kumar
hi this is tulasi ravi
id - ravi106109@gmail.com
select empno,sal 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 ? | 3 Yes | 5 No |
Post New Answer View All Answers
Why I have to use stored procedures?
What should be the fill factor for indexes created on tables? : sql server database administration
What are the advantages of using third-party tools?
What are trace flags and mention a few common trace flags used with sql server?
What is the syntax to execute the sys.dm_db_missing_index_details?
Tell about MOM Tool(Microsoft Operator Manager)?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Explain Geometry datatype in sql server 2008 with example
What are the differences between stored procedure and the dynamic sql?
How use inner join in sql server?
Explain trigger and its types?
how many triggers you can have on a table? : Sql server database administration
What are different types of roles provided by ssrs?
What is usually the first word in a sql query?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
