How many defaults can be placed on one column of a able.If this col had an existing default, what will happen if one more is added?
Latest Answer: natural join is basically a form of equi join where one of the join fields is projected out. i.e. it avoids repeatition of the join column. ex:select pub.id,pub.name,au.*from publisher pub, author auwhere pub.id = au.id --- this query depicts a natural ...
Latest Answer: I think you can use below one..select * from (select * from table_name order by asce)where rownum >=2 ...
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 ...
Latest Answer: count(1) will be faster than count(*) because it counts the first column values with not null ...
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?
View page << Previous 2 3 4 5 [6]
Go Top
