 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 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? Read Answers (1) | Asked by : Sudeep Biswas Latest Answer : Oracle has PL/SQL for stored procedures whereas Sybase uses T-SQL ... Read Answers (2) | Asked by : ramesh Latest Answer : Let me clarify that while Sybase does not have "Object Tables" it can hold BLOBS in columns in tables. These can be of datatype TEXT or IMAGE.Sybase has the concept of Temporary tables in the form of #temp_tables or tables residing in the tempdb database.A ... Read Answers (2) | Asked by : Senthil Latest Answer : Before knowing about Sybase transaction commit it is first essential to know about Sybase transaction. Sybase transaction is nothing but a number of SQL statements paced and handled between Sybase BEGIN TRANSACTION and Sybase COMMIT or ROLLBACK statement. ... Latest Answer : 1. Select * from <database name>..<Table name> 2. Use <database name>
go ... 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
) ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
