Interested to Buy Any Domain ? << Click Here >> for more details...
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
1133Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
1476Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
1895Post New Databases AllOther Questions
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
Explain database partitioning.
What is a database connection string?
What are database connection details?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
Differentiate between delete and truncate table?
What is table scan and index scan?
What will happen non-clustered index will be created on clustered index?
Explain entity type?
What are the advantages of views in a database?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
Why merge statement is used inside the database?
what are wrappers and build ups and what it's use?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
Give the syntax of exception handling used in DBMS?
