What is index?
Answer / raj
The index is Nothing but quickly show the data on screen.
it's used for fast retrivel of data from tables.
| Is This Answer Correct ? | 9 Yes | 0 No |
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Define right outer join in sql server joins?
List out the differences between global and local temp tables in sql server?
What are partitioned views and distributed partitioned views?
What are policy management terms?
What does top operator do?
What is an identity column in insert statements?
What are group functions in query statements in ms sql server?
Why do we use non clustered index?
What is difference between temp table and cte?
What types of replication are supported in sql server?
what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?
Oracle (3253)
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)