Learn T-SQL Commands with Samples
Skip Navigation Links
Skip Navigation Links.
Expand DatabaseDatabase
Expand TableTable
Expand ViewView
Expand Stored ProcedureStored Procedure
Collapse Data FilteringData Filtering
Expand Data GroupingData Grouping
Expand JoinsJoins
Expand TriggerTrigger
Expand CursorCursor
Expand OperatorsOperators
Expand ConstraintsConstraints
Expand FunctionsFunctions
Expand Conditional ProcessingConditional Processing
Expand LoopingLooping
Expand Error HandlingError Handling
Expand v.IMP Queriesv.IMP Queries
Expand XMLXML
Expand Query PerformanceQuery Performance
Expand QueriesQueries
Expand NormalizationNormalization
Expand CreateCreate
     

Top

  
      

      
EMP


      

      ID
      Name
      Country
      Salary
      


      

      1
      Vijay     
      India     
      6000
      


      

      2
      Bill      
      USA       
      8000
      


      

      3
      Kris      
      France    
      3000
      


      

      4
      Bhagat    
      India     
      2000
      


      

      5
      Steve     
      USA       
      1000
      


      

    
      SELECT  TOP 3          *  FROM    EMP

      SELECT  TOP 75 PERCENT *  FROM    EMP
    
      

      

      Output
      

      

      ID      
      Name    
      Country 
      Salary 
      

      

      1
      Vijay
      India
      6000
      

      

      2
      Bill
      USA
      8000
      

      

      3
      Kris
      France
      3000