 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 (12) | Asked by : RK Latest Answer : We can do remove the duplicate records using the below single queryDelete from table1 where rowid not in (select max(rowid) from table1 group by dup_col) ... Read Answers (7) | Asked by : Pat Latest Answer : The query isselect max(sal) from emp where sal < (select max(sal) from emp where rownum ... Read Answers (23) | 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 : 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 ... Why can a user create 249 non clustered indexes over a given table as against only one clustered index over a table? Latest Answer : Partition is a old technology helps to access data faster (not actually faster) in almost all the databases. Sybase ASE 15.0 opens up a new possiblity of this. Sybase ASE contains semantic Partioning which is not available in Oracle latest version called ... A column name is given to you. You have to find out which table has that column. Database has 230 tables. For example: empid (column name) For this how do you find out which table has the column (empid) ? Read Answers (5) | Asked by : Karthi How to find out the maximum sales of an item for each sales man.The table consists sales_man, item, sales columns, each sales man will have the different sales values for different items.here I have to find out for every sales man, which item he sold maximum Read Answers (3) | Asked by : Bob
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
