|
Question |
Rating |
View Answer |
|
How to find second maximum value from a table?
|
|
View Answer |
|
What the difference between UNION and UNIONALL?
|
|
View Answer |
|
What is the advantage to use trigger in your PL?
|
|
View Answer |
|
When using a count(disitnct) is it better to use a self-join or temp table to find redundant data, and provide an example?
|
|
View Answer |
|
Difference between Stored Procedure and Trigger
|
|
View Answer |
|
I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.
|
|
View Answer |
|
on index why u need indexing ? where that is stroed and what u mean by schema object? for what purpose we are using view
|
|
View Answer |
|
what is the difference between oracle,sql and sql server
|
|
View Answer |
|
How to retrieving the data from 11th column to n th column in a table.
|
|
View Answer |
|
Difference between decode and case. in which case we are using case and in which case we are using decode? with an example.
|
|
View Answer |
|
How to delete same id in rows? For example empid=5 repeated for times in rows. How to delete which sql query is used? |
|
View Answer |
|
what is the difference between replace and translate functions? |
|
View Answer |
|
lets i have a table "bapi" having 6 field like this f1 f2 f3 f4 f5 f6 ... ... .. ... ... ... p r o m o d
i want to retrive all the data by using select statement and my output will be look like this: xyz ... p r o m o d |
|
View Answer |
|
What is the use of indexes?Explain about it? |
|
View Answer |
|
1. How to create a new table? 2. How to insert another column into the table? |
|
View Answer |
|
What is the difference between @@identity and SCOPE_IDENTITY()? |
|
View Answer |
|
What is a clustered index? |
|
View Answer |
|
what is the query for to select multiple columns to generate single row in the sql and how come we can bring grid views in sql for getting those datas are demolished
|
|
View Answer |
|
What columns would you use as a clustered index on a retail store address table? |
|
View Answer |
|
How to testdata loading in database testing? |
|
View Answer |