Complex sas interview questions
![complex sas interview questions complex sas interview questions](https://2.bp.blogspot.com/-4ZRGveet1KE/V5SGjbSWthI/AAAAAAAAE9Q/e_ybEurskV04OC61Q9hwrsw9gguKC-ExQCLcB/s1600/advanced%2Bsas.png)
Question 6 :What is dense_rank Explain with examples.ĭense Rank analytical function is same as rank but it has assigned the consecutive rank for Tie values in the table.So Disadvantage of rank function has been overcome in Dense_Rank function.Dense rank function is useful to give the rank for the SQL values in the table.It is not repeating the rank values so these functions are really very useful in development of reports where we require actual rank values. So there is no functional difference between Unique and distinct both have same functionalities. Duplicate rows are those with matching values for each expression in the select list. There is no difference between unique and distinct keywords apart from one difference.unique is applied before insertion and retrival.It consists of non duplicate values.if unique constraint is given it does not take duplicate values.distinct is used in retrieval it gives the suppressed row(ex if two rows are same it will show single row and non duplicate row) therefore distinct is the combination of suppressed duplicate and non duplicate rows.Specify DISTINCT or UNIQUE if you want Oracle to return only one copy of each set of duplicate rows selected (these two keywords are synonymous). Question 5 : What is difference between unique and distinct?(90% asked Advanced SQL Interview Questions ) Some of the object privileges are EXECUTE, INSERT, UPDATE, DELETE, SELECT, FLUSH, LOAD, INDEX, REFERENCES etc.
![complex sas interview questions complex sas interview questions](https://i.ytimg.com/vi/bq4-xLP7I2Y/maxresdefault.jpg)
Question 1 : Is there any way to find out column is indexed or not? If yes how? The Advanced SQL Interview Questions contains the questions with complex sql as well as questions with different advanced SQL. This article will give you the idea about important Advanced SQL Interview Questions with its answers. This article gives you idea about the Advanced SQL Interview Questions with answers.
![complex sas interview questions complex sas interview questions](https://i.pinimg.com/originals/3b/03/fc/3b03fc25252fff0671207ca7b7a371e9.png)
In my previous articles I have explained different interview questions related to SQL with its answers.