SQL

You have data of people having applied for a lottery ticket. The data consists of their name and ticket number. You have to choose winners by selecting the people present in the alternate rows (first winner starting from row number ...

Write a query for collecting the names of children who pursuing their graduation in their residential city. NAME AGE ADDRESS COLLEGE ……. …… ….. ….. (Hint- Look for the common city name in the columns of ADDRESS and COLLEGE) Example Nitin 26 Patna Patna Ankit 27 Bangalore Pune Result - Nitin

Sometimes you are not given a problem, but are asked to create one along with the solution. You will understand this concept through the next question. What is the function of OFFSET command? You might know the definition but create a ...

NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August You are supposed to provide a salary raise to the employees who have joined after the 31 June. Collect the names of the employees who satisfy the condition.

NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August   Get the details of the employees whose "FirstName" does not start with any of the characters between 'c-r'

NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August   How will you get the data of the Nth highest salary from the table? Also, find the third highest salary by substituting values of N.

NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August   Get all the employee detail from Employee Detail table whose "FirstName" starts with A and contain 5 letters.

Write a suitable query where you will collect the names of visitors in a conference who have less than 8 characters in their name. Also, separate the ones with a middle name. (Hint- You can take appropriate column_names)

How can you create an empty table from an existing table? Write the steps and explain the working. Take the following table for instance and create a new table named as cstudent. NAME MARKS ROLL NUMBER Ashutosh 87 1001 Bhavya 92 1002 Garima 69 1003 Pratham 75 1004 Sushant 90 1005

Write an SQL Query find number of employees whose DOB is between 01/07/1965 to 31/12/1975. Collect the data separately for different gender. Use column name as sex, DOB table name Employees. (Hint- Imagine a hypothetical data)