Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40788 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
Answer Posted / sajida
--For ex in dept table to select 5th record. Instead of
this you can use &n so that it can ask row number
select rnum, d.* from dept d, (select rownum rnum ,
deptno from dept ) e
where d.deptno = e.deptno and rnum = 5
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
Does windows server 2016 come with sql server?
How to query multiple tables jointly?
What is the filtered index?
Can you explain powershell included in sql server 2008?
What happens if ntwdblib.dll is missing on your machine?
Can you import Microsoft Excel data to SSRS?
What is the difference between drop table and truncate table?
How to edit table in sql server 2017?
What is the command used to recompile the stored procedure at run time?
How many replicas are maintained for each sql azure db?
Why are you getting errors when creating a new odbc dsn?
What are the disadvantages of using the stored procedures?
What is the difference between ‘having’ clause and a ‘where’ clause?
How to insert stored procedure result into temporary table?
How do you send email on SQL Server?
