Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?
- 16 Answers
- 25210 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / vishnu
select top 1 * from (select top 5 * from employee order by
empid)sub order by empid desc
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are constraints? : Sql server database administration
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What are the new features are introduced in sql server 2012 reporting services?
What is the difference between a view and a stored procedure?
Explain what are various ways to enhance the ssrs report?
Explain what is cte (common table expression)?
Why use identity in sql server?
what data regions are and what are the different data regions?
What is difference between drop truncate and delete?
Mention the differences between substr and charindex in sql server.
What is the process of normalising?
Can primary key be a foreign key?
What is data source view or dsv? : sql server analysis services, ssas
What are orphan records?
What is the difference between for xml raw and for xml auto?
