aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • SQL and Informatica Fundamentals
  • EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A97...
Multiple choice technology databases

EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH 2850 A500 BALAJI 5750 Use these data for the following Questions: Select SAL from EMP E1 where 3 > ( Select count(*) from Emp E2 Where E1.SAL > E2.SAL ) will retrieve

  1. 3500,5000,2500

  2. 5000,2850

  3. 2850,5750

  4. 5000,5750

Reveal answer Fill a bubble to check yourself
A Correct answer

Keep practicing — related questions

  • Use these data for the following Questions EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH...
  • Use these data for the following Questions EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH...
  • Use these data for the following Questions EMPNO ENAME SAL E100 John 3250 E200 Praveen 2000 E300 Mahesh E40...
  • Use these data for the following Questions EMPNO ENAME SAL E100 John 3250 E200 Praveen 2000 E300 Mahesh E40...
  • Consider the emp table having columns empno, ename Which of the following SQL query fetches empno that occu...
  • "select E_Name,E_Number from EMP order by 2" This Query is
  • Consider an emp table having columns empno, empname, salary Which of the following queries sort emp table b...
  • SELECT ename FROM emp WHERE ename LIKE '%A_E%'; Which name from the following names can selected by the abo...
Play the full quiz 🎤 Practise this topic out loud

Practice this topic

  • Database and SQL (3929 questions)
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy