|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions There are 2 tables, Employee and Department. There are few records in employee table, for which, the There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query? Read Answers (11) | Asked by : RK Latest Answer : But this will remove all the db constraints from the table.... am I right...so we can do the same like as follows:select * into temp_1 from Original ---so no constraints are droppedtruncate table Originalinsert into Originalselect distinct * from temp_1drop ... Read Answers (6) | Asked by : Pat Latest Answer : Top function is only working in sql server, please ignore it. if you include any clolumn with max() function it will not give proper output.guys, if you want to need minimum 2 salary from emp table in syabse please follow the below query. select salary ... Read Answers (22) | Asked by : kosmos Latest Answer : Live table will be created using:
1.
Create table
(
column name datatype
)
2.
Select * into from
e-x: select * into new_emp from emp
Temp Table will be created using:
1.
Create table <#table name>
(
column name datatype
) ... Latest Answer : The minimum table size is equal to 1 extent (that is equal to 8 pages). ... Latest Answer : Clustered index and Nonclustered indexes are the two type’s index handled by Sybase. In the case of Clustered index the physical and logical order are maintained in the same order by the process of sorting and resorting as required for maintenance ... Latest Answer : The table in Sybase can be deleted by using the command drop table. The syntax of this command is as below:drop table Then the window waits for entering the table name where the table name to be deleted in Sybase is entered and go is entered which results ... Latest Answer : Index are handled automatically by Sybase database to speed up the query and in short to optimize the query .But in certain scenarios and situation the user may need to force the index for handling the inaccurate results shown by optimizer. This concept ... Latest Answer : The data that are fetched by the SQL (select statement) is completely fetched from the index itself is called index covering.Example:-- TableA has 10 columns Col1, Col2, Col3, Col4, Col5...-- An index idx_TableA on TableA has composite non-clustered index ... Read Answers (2) | Asked by : Keerthana Why can a user create 249 non clustered indexes over a given table as against only one clustered index over a table?
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
