Oracle Interview question How To Get unique records without using distinct in oracle

Oracle Interview question How To Get unique records without using distinct in oracle?

List of all the SQL and PLSQL interview questions

[ghousehussain]

Super sir you're the life saver.
For my work i need to filter the column data. But tried with all possible options like distinct unique etc..but row_number partition worked like charm ❤️

[TysonGill]

Hi siva,

Thanks for the video, i wanted to know the difference between distinct and unique function used here.

Regards

[bharathibalakrishnan]

Helps to refresh and nice examples. Thank you

[sanathkumarks]

Hi shiv, in mysql workbench by using union keyword it is not fetching uniqe records is there any other way in mysql.

[yashwani]

For the correlated query, wouldn't the count be equal to 2 when 3 rows are repeated for a particular record? Can someone explain explain please?

[mohanpavan]

Siva can you please clarify one doubt as a general, when we use 1=2 in the where clause it means it’s false and hence create or select will not be performed but in below query why is table being created but with no data? Create table emp1 as select * from emp where 1=2;

[kumarkumar-fmoy]

Thanks siva.

I have 15k records in table .
Can we fetch at a time using select query. I have only read access.

Please suggest.
Thanks.

[vivektarab]

Start

1:19 - Some queries Examples

2:44 - Using Distinct Keyword

2:54 - With Unique Keyword

3:11 - Using Group by

4:11 - Using Union

5:19 - Union with Nulls

6:13 - Using Intersect Operator

6:35 - Using Minus Operator

7:11 - Using Row_Number ()

7:55 - Using Rank or DenseRank

8:31 - Two more ways - One is Using RowID - Using Subquery

8:53 - Using RowID with Corelated Subquery

9:11 - Recap all these Queries

[kalpeshpatil]

Can you please make a video on regular expression and type of regular expression with small example in easy way to get it understand.
It will be very thankful, if you make video on this.
Thanks in advance cheers.

[g.sreekanthreddy]

Hi Siva

Can you pls do post videos on sql nd performance tuning?
Thanks in advance

[prashantgupta]

Hi Sir,
How can we call URL in procedure

[venkatamaddina]

Very helpful. Can we get some videos on AWR report interpretation and the performance tuning tips and Partitions in Oracle

[qpoveic]

can you recheck the correlated one, its not giving the proper output when checked in db

[bharathipandian]

Siva, at 6.09 how it works select rollno, name from emp union select null, null from dual 1=2...null is not comparable with anyvalue pls explain

[ankursrivastava]

The way in which you used to filter the unique records
Select null, null from dual where 1=2, if we have 4 columns in the first select list, will that work ?

[pradipmunjamkar]

Which way have better performance when working with millions of records??

[bharathipandian]

Hi siva, when I got this question from an interview panel, I wrote using row number analytical function, it is correct. But the panel asked why you are making life complex.... Then he told me that you would have written using rowid.. So pls suggest me when they expect me a single query from me what should I say

[mssudharshanreddy]

Siva sir,


in one of the interview i got a question like "you need to delete duplicates without using rowid or rownum.only one record should be present.duplicates should be deleted.11' how can we do this ?

[googdriveforme]

But on interview if some one asks this question reply them "there are many ways to get distinct record but using Oracle key words boost the performance so using distinct keyword is the right choice.

[vilasgaikwad]

Hi Siva,
How to find missing values of table.