Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 41327 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
Answer Posted / saravanan p
select * from
(select row_number() over(order by empid) rno,* from tbl)
tbl1
where tbl1.rno=n
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
What is change data capture (cdc) in sql server 2008?
What is key set driven?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is checkpoint in sql server?
How to convert binary strings into integers in ms sql server?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What are sql servers used for?
How is SQL Azure different than SQL server?
How do we synchronize On-Premise SQL server with SQL Azure?
What is a synonym for manipulation?
What do you mean by normalisation?
Why I can not enter 0.001 second in date and time literals in ms sql server?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What is the recursive stored procedure in sql server?
What are the differences between clustered and non-clustered index?
