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
- 25851 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
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 to see existing views in ms sql server?
How much is a sql server license?
Describe in brief databases and sql server databases architecture.
What is an indice?
What are the authentication modes in sql server? How can it be changed?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What causes index fragmentation?
What are audit control procedures?
In which tcp/ip port does sql server run? Can it be changed?
Mention the differences between local and global temporary tables.
Why use triggers?
What is a subquery in a select query statement in ms sql server?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What are secondary xml indexes?
