#Adventureworks database practice problems how to#
These are above some SQL Practice Exercises with Solutions which are highly used in real life scenarios.In out SQL Practice Exercises with Solutions we are using the Regular expression function named REGEXP_LIKE to check for Email validation.įOR ANY SQL SUPPORT CONTACT : 10 : How to fetch maximum salary of Employee and minimum salary of Employee together from Employee table. User needs to use regular expression function to check the Email validation with single query. Here we are using lpad() function to fetch dollar symbol.Įxample 9 :How to check for Email is correct or wrong with using single query.
SELECT lpad (‘$’, ROWNUM,’$’) FROM Employee WHERE ROWNUM <4 We need to use Employee table with data more than 4 to perform this. We can not use dual table to perform this operation. Here we are using the operator from SQL to delete duplicate rows from the table.Įxample 8 : How user can display following structure with using single SQL Query. (Select max (rowid) from Employee b where Employee_num=b.Employee_num) There are situations where user needs to find out the duplicate rows as well as delete those rows. Using above query we find out the duplicate record count from the table. You need to use order by clause as well.Įxample 7 : How to delete duplicate rows from the table. In this example we need to use the Count function as well as group by and having. There are some situations where user needs to fetch some last records from the table.The following query will fetch the last records from the table. The condition 1=2 means True=False which is always False condition.So with using the above query user can create duplicate table structure without data.Įxample 3 : How to display Last 10 records from Student table. The above query will create the same table as student named ‘Student_Replica’ without data.It is possible due to the condition 1=2. Let us consider that user wants to create a replica of table named ‘Student’ without having data. Example 2 : How to create table with same structure without data? The above query will create the same table as student named ‘Student_Replica’ with its data. Let us consider that user wants to create a replica of table named ‘Student’.Ĭreate table Student_Replica as Select * from Student Important Queries for SQL Practice Exercises with Solutions : Example 1 : How to create table with same structure with data? I have already written article on real world industry examples of SQL.I want to add some queries from that article also.There are following SQL Practice Exercises with Solutions which are mostly used in day to day life in world of programming. The origin column in the SHOW DATABASES output (or the Origin column in the Databases page in the interface) displays the fully-qualified name of the sharedĭatabase, SFC_SAMPLES.SAMPLE_DATA, indicating it originated from the SFC_SAMPLES account (used by Snowflake to share the sample data).In my previous article i have given the different examples of SQL as well as most important complex sql queries for interview purpose.I would like to combine all those examples and want to make one best article on SQL Practice Exercises with solutions.My main purpose writing this article on SQL Practice Exercises with solution is to get idea about different SQL real world examples as well as user can easily implement it in day to day life.These are the scenarios which are useful for real world industry. Note that this example illustrates the sample database, SNOWFLAKE_SAMPLE_DATA, has been shared with your account by Snowflake. Sample Data: OpenWeatherMap - Deprecated.Querying Tables and Views in the Sample Database.
0 kommentar(er)
