What is the unique index?
How do you concatenate in sql?
Is left join faster than join?
What are the types of triggers ?
26 Answers Aspire, BirlaSoft, TCS,
Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d
What is using in sql?
I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...
what are myisam tables? : Sql dba
What is materialised View?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
there are .......different types of serializability
Write an sql query to select all records from the table?
select 10 from dual; y its showing all the rows with 10?