Interested to Buy Any Domain ? << Click Here >> for more details...
What is sorting and what is the difference between sorting
and clustered indexes?
- 1 Answers
- 7997 Views
- I also Faced
- E-Mail Answers
Answer / saravakumar
The ORDER BY clause sorts query results by one or more
columns up to 8,060 bytes. This will happen by the time when
we retrieve data from database. Clustered indexes physically
sorting data, while inserting/updating the table.
| Is This Answer Correct ? | 5 Yes | 1 No |
select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?
How to create a new login name in ms sql server?
What is openrowset sql server?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What are “unrepeatable reads”?
What is store procedure?
What is a covering index?
Tell me the phases a transaction has to undergo?
how to improve the speed of SQL database server and how to avoid dead lock?
What are the new features in SQL Server 2005?
What is onf in normalization form?
Why do we need different type of parameter?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
