|
Related Questions |
View Answer |
|
What is outer join?Explain with examples.
|
View Answer
|
|
What is DML,DDL?
|
View Answer
|
|
How we get second highest salary in database. Please show me this coding.
|
View Answer
|
|
How to analyze the performance of a query using Explain Plan? Can any one explain me this in detail... if you can provide me with a link where I can get full information on it I would appreciate it...?
|
View Answer
|
|
Explain the concept of joins and list out the different type of joins?
|
View Answer
|
|
What is the difference between varchar & varchar2?
|
View Answer
|
|
what is analyze command how to use ?
|
View Answer
|
|
How you define which session run and how long time ?
|
View Answer
|
|
How to save the output of a query/ stored procedure to a text file using T-SQL?
|
View Answer
|
|
How to get the first day of the week, last day of the week and last day of the month using T-SQL date functions?
|
View Answer
|
|
How to programmatically find out when the SQL Server service started?
|
View Answer
|
|
Write a Query to find unique names of authors who have written books. (Using Pubs database)?
|
View Answer
|
|
Write a Query to pull out the maximum unit price for each in the database. (Using Northwind database)
|
View Answer
|
|
Write a SQL statement to draw the second highest salary in Employee Table (Using Sub query) Table structure is: Employe ID Name Salary
|
View Answer
|
|
What is a default TCP/IP socket assigned for SQL Server?
|
View Answer
|
|
What is a default TCP/IP socket assigned for SQL Server?
|
View Answer
|
|
What’s the difference between a primary key and a unique key?
|
View Answer
|
|
How to retrieve the image from the database?
|
View Answer
|
|
How to find the second highest salary from employee table? and how to write it?
|
View Answer
|
|
How to transfer some amount from one person's account to another's ?
|
View Answer
|