-
Joiner Transformation Limitations
What are limitations and delimitations of Joiner Transformation?
-
Semi Additive and Factless Fact Tables
Which scenario will use semi additive and factless fact tables?
-
Birthdate Query
There is a table friends having following detailsName BirthdayJohn 28-jun-1985Peter 27-aug-1987Tom 13-aug-1986Nick 29-apr-1987Natalia 25-apr-1984Kate 28-jun-1984Wilson 11-nov-1987krish 31-jul-1987robert 25-apr-1984 SELECT names of the friends which come on the same day.. condition you don't know which birthday's repeat SELECT distinct...
-
Produce a List of 5 Highest Revenue Transactions
You need to produce a list of the five highest revenue transactions from the Orders table in the Sales database. The Orders table is defined as follows:CREATE TABLE Orders ( OrderID Int IDENTITY NOT NULL, SalesPersonID Int NOT NULL, RegionID Int NOT NULL, OrderDate Datetime NOT NULL, OrderAmount Int NOT NULL ) Which statement will produce the report correctly?...
-
Data Conversion
Have 2 table Emp1 (Column Name: Ename), 2nd table Emp2 (Column Name: First and Column Name: LastTable Name :Emp1ENameHunt, MichaelGraham, SmithNelson, Ryan Table Name: Emp2First LastMichael HuntSmith GrahamRyan NelsonNeed to write a SQL query to convert the data from Emp1 to Emp2 in this way.Can any body help me.Thanks
-
Find second lowest salary from emp table
display the second lowest salary from emp table without using min & all
-
-
-
-
-
-
-
-
-
-
There is a % sign in one field of a column. What will be the query to find it?
'' Should be used before '%'.
-
How you will avoid duplicating records in a query?
By using DISTINCT