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
- 25659 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
Difference between group by clause and having clause in SQL?
What is table-valued sub query?
Define msdb database?
Define clusters?
What are the three different part of rdl file explain them?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
Can we perform backup restore operation on tempdb? : sql server database administration
Do you know what are the reporting services components?
What is resource db in sql server?
What is the default server name for sql server?
What are the built in functions in sql server?
What is advantage data architect?
What is the difference between clustered and a non-clustered index?
Tell me about builtinadministrator?
What are the different types of locks in the database?
