Answer / rekha

select top 100 (field name)from table name order by (field
name) desc

Answer / zulfikar ali

SELECT TOP 100 FIELD_NAME
FROM TABLE_NAME
ORDER BY FIELD_NAME DESC

Answer / veeresh kethari

set rowcount 100
select * from tablename

Answer / veeresh kethari

SET ROWCOUNT 100

SELECT * FROM TABLENAME

Answer / karthi

select top 100 fieldname from tablename

Answer / ashis dey

select top 100 fieldname from tablename group by fieldname

Answer / vikas

select top 100 max(field name) from Table Name

What are temporal tables in sql server 2016?

0 Answers  

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

Which Model uses the SET concept

0 Answers   Infosys,

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?

0 Answers   TCS,

What is log cache in sql server?

0 Answers  

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

What is forward - only cursors / read only cursor?

0 Answers  

Explain the cursor lock types?

0 Answers  

what is curser.

9 Answers  

What are the types of model in sql server and explain

2 Answers   TCS,

What is the security model used in sql server 2005?

0 Answers  

What is lookup override?

0 Answers   Informatica,