define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.
5 12267there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
12 19911While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
8 17068write a query to delete similar records in particular fields(columns) in different tables
TCS,
6 13919
What are the two characteristics of a primary key?
Can a varchar be a primary key?
How do I trace sql profiler?
What are different functions in sql?
how to use case expression? : Sql dba
what are the different tables present in mysql? : Sql dba
What are the various restrictions imposed on view in terms of dml?
Is pl sql and postgresql same?
what are the join types in tsql? : Transact sql
what are date and time functions in mysql? : Sql dba
Is grant a ddl statement?
How many types of normalization are there?
How to use distinct and count in sql query? Explain
What does the hierarchical profiler does?
Why are indexes and views important to an organization?