If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
No Answer is Posted For this Question
Be the First to Post Answer
An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Explain trigger and its types?
What is Command line parameters in PLSQL.?
Explain what are the restrictions while creating batches in sql server?
Wht is the difference between stored procedure and trigger
What is table constraint?
What are the steps need to be take improve the speed of a SQLDATA Server?
If no size is defined while creating the database, what size will the database have?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)