What is an index. What are the types?
Is SET a SQL Keyword?
How to test values returned by a subquery with the in operator?
What is 1nf normalization form?
how to get rank of diffrent student in same table based on newly inserted row in sql server2008
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Explain what is the use of custom fields in report?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output
What is partition index in sql server?
How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com
35 Answers Oracle, Scend, TechInfini,
What is query processing?
What is the partitioning method?