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
How do I start sql server 2016?
What is named calculation? : sql server analysis services, ssas
When I run the sql server 2000 setup, it just hangs. What do I do?
How to generate random numbers with the rand() function in ms sql server?
Is it possible to call a stored procedure within a stored procedure?
Write a sql query to display the current date?
What is entity data services?
What are the restrictions that views have to follow? : SQL Server Architecture
How to perform key word search in tables?
What method is used by the Command classes to execute SQL statements that return single values?
How to transfer a table from one schema to another?
What is the use of builtinadministrators group in sql server? : sql server security
What is user-defined inline table-valued function?
How many types of attribute relationships are there? : sql server analysis services, ssas
What are different types of roles provided by ssrs?