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
- 26282 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / senthilkumar
SELECT TOP 1 Empid
FROM (SELECT DISTINCT TOP 6 Empid FROM Employees ORDER
BY Empid desc) a ORDER BY Empid asc
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
When is update_statistics command used?
What is difference between oltp and olap?
What is co-related sub query?
Can sub report data source be different from that of the parent report?
what are constraints? Explain different types of constraints? : Sql server database administration
What is index fragmentation in ms sql server?
Define ACID properties in a Database?
What is user-defined multi-statement table-valued function?
How do I find my localdb version?
What are the basic features of a trigger in ms sql server?
What is data source object?
What are the types of resultset?
what is the system function to get current user's user id? : Sql server database administration
