Q&A Categories

Database

You are writing a report that needs to format data being extracted from the database on the screen.

You are writing a report that needs to format data being extracted from the database on the screen. All data relates to a specific object, but there are a variable amount of tables, and each table has...

Answers No Answers In: Database By: rakesh [ Grey Star Level] Sep 8, 2010

You have EMP and dept table .how do you get the entire department and corresponding employee details

You have EMP and dept table .how do you get the entire department and corresponding employee details and the department which are not alloted it?what is referential integrity constraint?wat is triggers,stored...

Answers No Answers In: SQL By: deva [1 Grey Star Level] Sep 8, 2010

Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform

Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform a full database backup. You decide to implement the following backup strategy : Full backup : 9am...

Write query for the following questions1. sql query for selecting alternate rows in a table2. sql query

Write query for the following questions1. sql query for selecting alternate rows in a table2. sql query for deleting alternate rows in a table '

Answers No Answers In: SQL By: sam [ Grey Star Level] Sep 7, 2010

Write sql query for retrieving employee names from employee table who are having salary greater than

Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause? '

Write a query to display alternate records from the employee table?

Write a query to display alternate records from the employee table? '

Answers No Answers In: SQL By: neha [ Grey Star Level] Sep 7, 2010

Write a query to display employee records having same salary?

Write a query to display employee records having same salary? '

Answers No Answers In: SQL By: ramesh [ Grey Star Level] Sep 7, 2010

Write a query to find the list of employees whos age is greater than 30 or so given a date of birth

Write a query to find the list of employees whos age is greater than 30 or so given a date of birth column '

Answers No Answers In: SQL By: samir [ Grey Star Level] Sep 7, 2010

Write a query to update third column such that

Write a query to update third column such that There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 ...

Answers No Answers In: SQL By: nitin [ Grey Star Level] Sep 7, 2010

Within UNIFY can an SQL be written to update a field beginning at a particular start byte in the field?

Within UNIFY can an SQL be written to update a field beginning at a particular start byte in the field? Ex. Field is 16 characters long and data in field is as follows ' nnbc2 n '. Data...

Answers No Answers In: Unify By: bipin [ Grey Star Level] Sep 7, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]