how to select 5 to 7 rows from a table, which contains 10 rows?
Answer Posted / govind
select * from emp where empid between 5 and 7
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
In what sequence sql statement is processed?
How to connect a database with sql express.?
Explain steps of normalization?
Explain timestamp datatype?
How to check if stored procedure is running in sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Explain isolation levels that sql server supports?
What structure can you implement for the database to speed up table reads?
Can we write trigger for view?
What is join and name different type of joins?
What is the recommended total size of your memory optimized tables?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is an entity-relationship diagram (erd)?
What stored procedure would you use to view lock information?
What is usually the first word in a sql query?