Oracle (3259)
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) C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.
2619What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
TCS,
3934hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju
4 6858How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
2 4693How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that
TCS,
9 11634
How can you ensure that the database and sql server based application perform well?
What is the purpose of the grep command?
What is database mirroring?
What is oracle real application clusters?
What is an Oracle Data Block?
Explain data independence & its types.
Will truncate release space?
What is the functionality and features provided by oracle clusterware?
How to add new employee details in an employee_details table with the following details
What is indexing in sql and its types?
what is an informix instance?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
Does mysql use tcp or udp?
What are the uses of Database Trigger ?
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL