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)?
Answer Posted / uma
all the answers are wrong,the questions is like this there
are 100 rows they want o/p to display is in betwwen 50 and
100 are displayed
select top 100 * from tablename where empid not in(
select top 50 empid from TABLENAME)
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is difference between foreign key and unique key?
What is serializable?
How to list all objects in a given schema?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How you provide security to cube? : sql server analysis services, ssas
What is candidate key with example?
Explain system scalar functions?
Why are sql functions used?
How to create a user name in a database?
What are the encryption mechanisms in sql server?
What is an identity?
What is a raid and what are different types of raid configurations?
How do you open a cluster administrator?
How can you start sql server in different modes?
Call by value and call by reference in procedure and function, with NOCOPY.