how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 21610 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / guest
select * from emp where EmpID between 5 and 7
| Is This Answer Correct ? | 7 Yes | 9 No |
Post New Answer View All Answers
Explain various On-Delete options in a DB table. Which is the default option?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What are the advantages of partitioning?
What is the meaning of sql server?
How to remove duplicate rows from table?
What is the difference between system objects and user objects?
What is collation?
Why should we go for stored procedures? Why not direct queries?
Characterize join and name diverse sorts of joins?
What is the importance of a recovery model?
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 an expression in ms sql server?
What is the use of toad or sqldbx.?
Explain the difference between HTTP and HTTPS in database?
What happens if you are trying to access a schema not owned by you?
