Question
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 ...
in progress 4
55 years 21 Answers 5880 views Great Grand Master

Question
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
in progress 3
55 years 20 Answers 5868 views Great Grand Master

Question
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 ...
in progress 1
55 years 5 Answers 2165 views Great Grand Master

Question
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.
in progress 1
55 years 7 Answers 2282 views Great Grand Master

Question
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'
in progress 0
55 years 7 Answers 1719 views Great Grand Master

Question
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.
in progress 1
55 years 10 Answers 2379 views Great Grand Master

Question
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.
in progress 0
55 years 4 Answers 1496 views Great Grand Master

Question
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)
in progress 1
55 years 6 Answers 1778 views Great Grand Master

Question
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
in progress 1
55 years 6 Answers 2499 views Great Grand Master